Forum

Hi Arun, Please see attached workbook. This sends email using Outlook so you'll need that installed. Emails are sent 'silently' - they aren't dis...

Hi Alison, Yes, you have to copy the entire format in one go. Please see attached workbook, which includes the custom format. To recreate thi...

Hi Arun, the code for emailing PDF's here should help you Regards Phil

Hi Julie, Are we deleting rows or columns? Which column(s) would pto, web cam, employee id etc appear? In order to look for something specifi...

Hi Julie, Yes this can be done. But the final macro will depend on what your data looks like. Can you please supply a workbook with data? Rega...

No worries Dan

You're welcome. Merry Christmas and see you in 2019. Phil

Hi Dan, In your pyxll.cfg you should have moth_ws.py listed under modules. Are you trying to run moth_ws from a console? It should be run by Py...

Hi David, If the macro works with test data but not with real data then your test data is not an accurate reflection of your real data. You need...

Hi David, there's no attachment. Phil

Hi Maurizio, You need to change this line RigaF = Split(Replace(lineafile, Chr(34), ""), ",") Your text file has each line wrapped in double ...

Hi Khaled, I don't know any way to do this from VBA. You'll find some stand alone utilities though if you do a search. Regards Phil

Hi Alison, You can follow the steps here but I would start with a blank document, rather than any template available in Word. Basically if ...

Hi Alison, The fields in the Word doc are mapped 1-1 from the source data (columns) for each record. So if you want to have multiple issues per Ow...

Hi Maurizio, I have to ask, why are you playing music in Excel? Why not just use a media player? Anyway, you can use ActiveX controls to do wha...