I have a report.xlsb file that is saved to a folder. This file doesn’t currently have any VBA coding. I have written a VBA text file which formats the report.
My plan is to modify this report from a “control sheet” for lack of a better term. (There will actually be multiple reports and departments.)
I’m looking for a way to insert this VBA code into a saved workbook without having to open it. If this isn’t possible then having the code open the workbook, insert the text file, then close the workbook.
Thank you, any help would be appreciated.