Hello; I'm wirting a macro to create records in a formatted form for each row in a spreadsheet
Everything works ok; I can create as many forms as rows are populated with information.
The issue I'm encountering is that the SaveCopyAs command creates files in version 2003; so every time I open the new created files a dialogue box appears to validate the file is ok to open. I'm creating hundreds of records.
I need help with my command line to create files in the same version I'm working on 2013.
Can anybody please help with suggestion for a different approach?
Thanks so much for your help.
this is the saving script in my macro:
-----------------------------------
branch = x.Sheets("Sheet1").Cells(count, 2).Value
newFileName = branch & "_ID" & count - 1 & ".xls"
ThisWorkbook.SaveCopyAs "C:\Users\My Documents\Temp\" + newFileName
----------------------------------
Bookmarks