I was hoping someone might have a solution to a problem I have.
Previously, I had a macro that would help me split files (so each row on the source excel file would become a file of its own), save the file as a pdf in a specified directory, and then rename the files (filename taken from the source excel). It was all working very well, until they upgraded our systems and disabled all macros. No amount of pleading to reeanable macros have worked, so at the moment I am mail merging and saving and renaming each file manually.
We are not able to install other software on our systems. Is there a "native" way via DOS or PowerShell or VBS that might be able to help me with this? Last year alone, I had to hit that button close to 180 times so I don't know how I will be able to manage life without that macro.... :'(
Would appreciate any insight / he/p !