I have nearly finished this project but have come across another problem.I have introduced a copy and save button. I have used this code in other workbooks and it works fine.In this workbook it copies ok but will not save.
Regards Troysie
Couple of things. You need to save as macro enabled excel file and you need to remove the forward slashes in order to have a valid filename.
wkbk.SaveAs Replace("C:\temp\" & Sheets("Sheet1").Range("A11") & ".xlsm", "/", "_"), XlFileFormat.xlOpenXMLWorkbookMacroEnabled
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks