Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as marco
I am trying to create a macro that will first save the file and then second
save as to a new location and new file name. Here is what I have and it doesn't work after the first save. Sub autosave() ActiveWorkbook.Save ChDir "R:\" ActiveWorkbook.SaveAs Filename:="R:\Service.xls", FileFormat:=xlNormal, _ Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False End Sub I tried it with and without the ChDir "R:\" and that did not work either. I also tried just ActiveWorkbook.SaveAs Filename:="R:\Service.xls" and that also did not work. Thank you for any and all help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as marco
Try changing your path to c:\temp ...and if that is working. check the folder
rights in R:\ Sub autosave() Dim strFileName as String strFileName = "R:\service.xls" ActiveWorkbook.Save ActiveWorkbook.SaveAs Filename:=strFileName End Sub -- If this post helps click Yes --------------- Jacob Skaria "John" wrote: I am trying to create a macro that will first save the file and then second save as to a new location and new file name. Here is what I have and it doesn't work after the first save. Sub autosave() ActiveWorkbook.Save ChDir "R:\" ActiveWorkbook.SaveAs Filename:="R:\Service.xls", FileFormat:=xlNormal, _ Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False End Sub I tried it with and without the ChDir "R:\" and that did not work either. I also tried just ActiveWorkbook.SaveAs Filename:="R:\Service.xls" and that also did not work. Thank you for any and all help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as marco
I changed the path to "C:\temp\servive.xls" and it still did not work.
I keep getting the code exexution has been interrupted box "Jacob Skaria" wrote: Try changing your path to c:\temp ...and if that is working. check the folder rights in R:\ Sub autosave() Dim strFileName as String strFileName = "R:\service.xls" ActiveWorkbook.Save ActiveWorkbook.SaveAs Filename:=strFileName End Sub -- If this post helps click Yes --------------- Jacob Skaria "John" wrote: I am trying to create a macro that will first save the file and then second save as to a new location and new file name. Here is what I have and it doesn't work after the first save. Sub autosave() ActiveWorkbook.Save ChDir "R:\" ActiveWorkbook.SaveAs Filename:="R:\Service.xls", FileFormat:=xlNormal, _ Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False End Sub I tried it with and without the ChDir "R:\" and that did not work either. I also tried just ActiveWorkbook.SaveAs Filename:="R:\Service.xls" and that also did not work. Thank you for any and all help. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as marco
You must be trying with a read-only file. Ignore save and go with Save As
'ActiveWorkbook.Save ActiveWorkbook.SaveAs Filename:=strFileName -- If this post helps click Yes --------------- Jacob Skaria "John" wrote: I changed the path to "C:\temp\servive.xls" and it still did not work. I keep getting the code exexution has been interrupted box "Jacob Skaria" wrote: Try changing your path to c:\temp ...and if that is working. check the folder rights in R:\ Sub autosave() Dim strFileName as String strFileName = "R:\service.xls" ActiveWorkbook.Save ActiveWorkbook.SaveAs Filename:=strFileName End Sub -- If this post helps click Yes --------------- Jacob Skaria "John" wrote: I am trying to create a macro that will first save the file and then second save as to a new location and new file name. Here is what I have and it doesn't work after the first save. Sub autosave() ActiveWorkbook.Save ChDir "R:\" ActiveWorkbook.SaveAs Filename:="R:\Service.xls", FileFormat:=xlNormal, _ Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False End Sub I tried it with and without the ChDir "R:\" and that did not work either. I also tried just ActiveWorkbook.SaveAs Filename:="R:\Service.xls" and that also did not work. Thank you for any and all help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this marco | Excel Programming | |||
Marco To Save Column A7 As A .txt File. | Excel Worksheet Functions | |||
How: Marco on Pivot Table to save as file up to 300 files | Excel Programming | |||
save file via Marco | Excel Programming | |||
marco | Excel Programming |