Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Help for Saving a file
Anyone, and everyone
I have a macro to save my spreadsheet. (I am saving it several times with diffrent names based on the data the macro pulls) The code is as follows: ActiveWorkbook.SaveAs Filename:= _ "I:\Commercial\0607\BVS\Master Bvs\ANU20.xls", FileFormat:=xlNormal _ , Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False Heres the trick, When it runs through its 5 times, every now and then I get a error 1004 message and the file is not saved. Now this can happen at any stage of the macro and has no rhyme or reason (That I can see) What do think? Is there a better way to do this? Doug |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Help for Saving a file
would it relate to the file name you are trying to use (possibly
illegal?) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Help for Saving a file
Don't Think so. Sometimes the first 4 of these run and it fails on the
5th. Somethimes it fails on the first. They are all saved to the same area just under different names. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Help for Saving a file
If, after the failure, the workbook ceases to be able to be saved "anywhere",
then your trouble may be coming from network hits occuring at random times, not really even related to your macro..... One thing you might try is to put this macro in a TEST workbook and see if it reacts the same, saving to your local drive directories rather than the network. Vaya con Dios Chuck, CABGx3 " wrote: Anyone, and everyone I have a macro to save my spreadsheet. (I am saving it several times with diffrent names based on the data the macro pulls) The code is as follows: ActiveWorkbook.SaveAs Filename:= _ "I:\Commercial\0607\BVS\Master Bvs\ANU20.xls", FileFormat:=xlNormal _ , Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False Heres the trick, When it runs through its 5 times, every now and then I get a error 1004 message and the file is not saved. Now this can happen at any stage of the macro and has no rhyme or reason (That I can see) What do think? Is there a better way to do this? Doug |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to run on the "Active Sheet" | Excel Discussion (Misc queries) | |||
Browsing/opening a file with a macro | Excel Discussion (Misc queries) | |||
Macro Save File (Unique file name) | Excel Worksheet Functions | |||
Problem Editing Macro in Shared Excel File | Excel Discussion (Misc queries) | |||
open file (as variable) from macro | Excel Discussion (Misc queries) |