My macro creates 20 workbooks, then saves each one to our Sharepoint drive. But for some reason today I'm getting an error code "1004 vba method saveas of object _workbook failed" during the save. The below code is representative of the code I'm using.. If I hit "Debug", then "Continue", it goes without a hitch, then fails on the next one. I'm just using the one line to do the save as. Any ideas why the code is failing (but obviously it still works)?Please Login or Register to view this content.
Bookmarks