Hello All,
I am getting a little complex here but I have some VBA code that generates and saves a new Excel file based on a form selection. I would then like the generated file to contain a couple of IF statements but I cannot get this code into the new file.
I have the following which works well (but might not be the most efficient way):
So that code creates a document that will be called number.xls and saves it to My Documents with all the information contained. Great. Now I want this newly generated document to contain the following:
Any idea how I can make sure that small section of code is contained in the new Excel document?
Thanks,
Chris
Bookmarks