Hi my name is XXXXX XXXXX I will be assisting you with your problem today!
This may be an issue between 2003 and 2007
Office 2003 considers Normal xls and not xlsx. In 2007 to save a xlsx file you use the XLworkbookDefault = 51.
Try using SaveAs('c:\test.xlsx', xlWorkbookDefault);
or equivalent for how you have that set up
Let me know if you are now able to open the generated file
ActiveWorkbook.SaveAs Filename:= _ template_file, FileFormat:= _ xlWorkbookDefault, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _ , CreateBackup:=False
Message states: "This extension cannot be used with the selected file type"
Remember this is an xlsm file
Answer did not work.
So I am thinking the only change you are suggesting is to substitute '51' for the xlFileType property and save to a folder off the root and force the file name to "Test.xlsx".
Works for xlsx......
When I run a test with an xlsm file type it fails as follows:
Dan please read my responses carefully.
My last response I told you I ran the test with xlsm and it failed with the following message:
You are starting to waste my time!!!!
52 is the answer
Not needed I found the issue and relayed to the last "expert".
Never again will I use this service.