What Can I do to trigger the macro through my Script?Īs I know this would trigger the macro automaticallyĪfter opening the Excel, solving my issue, But the problem is If i want to change something in my code later then first it would execute the macro and then would allow me to change the code, and I don't want that.
I had read that when exporting/saving this folder one should ensure that Firefox is closed. Recently I added the saving of my Firefox profiles folder. Hi, I am on windows 10/FF 78.01 and I have a batch file that on closure saves many things to another disk. It does open the File but doesn't trigger my macro(DoBirthdayRoutine) edited to correct the leading lines spaces, to allow content to wrap properly. Start 'C:\Program Files\Microsoft Office\Office14\EXCEL.EXE' 'C:\Users\rohitkap\Desktop\Rohit\Automatic Birthday mailer.xlsm' Please mark this post as answered if it answered your question. Please let me know that this works for you or if you have any questions.
Replace test.xlsm with the name and path for your file: You can start excel by creating a file with NotePad or a similar text editor.
