Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save to all computers on network from Excel 2007
Is there a way to save using VBA code from the current file to all the
computers on the network. Example: dim filetosave(3) as string filetosave(1)="\\Computer1\Documents\Books.xlsx" filetosave(2)="\\Computer2\Documents\Books.xlsx" filetosave(3)="\\Computer3\Documents\Books.xlsx" for k=1 to 3 'Save code goes here for each computer on network? next k I don't want to use saveas because it will clutter the 'Recent Documents'. Can anyone help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save to all computers on network from Excel 2007
hi
in theory, there should be no problem. i have had situations where i had a duel save to my harddrive and to a network drive or flash drive. all you need is all the file paths. and there could be issues with that if IT decides to change things. Oops. and there may be other issues. see this site for more details http://support.microsoft.com/kb/271513 you must use save as if its the first time saved to a location so as to establish the file path. after that a regular save is possible. here is an example of a duel save i use to save to my flash drive and c drive. i can't find an example i use to save to a net work drive. they are all at work. sorry. Sub FlashSave() Application.DisplayAlerts = False Application.StatusBar = "Saving to Flash" ChDir "G:\Excel" ActiveWorkbook.SaveAs Filename:="G:\Excel\Expences2009.xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False Application.StatusBar = "saving to c drive" ChDir "C:\Documents and Settings\FSt1\My Documents\XL" ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\FSt1\My Documents\XL\Expences2009.xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False Application.DisplayAlerts = True Application.StatusBar = False MsgBox "Finished Saving." End Sub regards FSt1 "Philosophaie" wrote: Is there a way to save using VBA code from the current file to all the computers on the network. Example: dim filetosave(3) as string filetosave(1)="\\Computer1\Documents\Books.xlsx" filetosave(2)="\\Computer2\Documents\Books.xlsx" filetosave(3)="\\Computer3\Documents\Books.xlsx" for k=1 to 3 'Save code goes here for each computer on network? next k I don't want to use saveas because it will clutter the 'Recent Documents'. Can anyone help? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save to all computers on network from Excel 2007
It's more reliable to use Save for the master copy of the workbook
(presumably on your hard drive) and use SaveCopyAs for any copies you want to make. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "FSt1" wrote in message ... hi in theory, there should be no problem. i have had situations where i had a duel save to my harddrive and to a network drive or flash drive. all you need is all the file paths. and there could be issues with that if IT decides to change things. Oops. and there may be other issues. see this site for more details http://support.microsoft.com/kb/271513 you must use save as if its the first time saved to a location so as to establish the file path. after that a regular save is possible. here is an example of a duel save i use to save to my flash drive and c drive. i can't find an example i use to save to a net work drive. they are all at work. sorry. Sub FlashSave() Application.DisplayAlerts = False Application.StatusBar = "Saving to Flash" ChDir "G:\Excel" ActiveWorkbook.SaveAs Filename:="G:\Excel\Expences2009.xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False Application.StatusBar = "saving to c drive" ChDir "C:\Documents and Settings\FSt1\My Documents\XL" ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\FSt1\My Documents\XL\Expences2009.xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False Application.DisplayAlerts = True Application.StatusBar = False MsgBox "Finished Saving." End Sub regards FSt1 "Philosophaie" wrote: Is there a way to save using VBA code from the current file to all the computers on the network. Example: dim filetosave(3) as string filetosave(1)="\\Computer1\Documents\Books.xlsx" filetosave(2)="\\Computer2\Documents\Books.xlsx" filetosave(3)="\\Computer3\Documents\Books.xlsx" for k=1 to 3 'Save code goes here for each computer on network? next k I don't want to use saveas because it will clutter the 'Recent Documents'. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Excel 2007 on a network where some computers have Office 200 | Excel Worksheet Functions | |||
After Excel 2007 install, cannot save files on network share | Excel Discussion (Misc queries) | |||
opening same file on 2 computers simultaneously with excel 2007 | Excel Discussion (Misc queries) | |||
Can I send files from Excel 2007 to computers using Excel 2003? | Excel Discussion (Misc queries) | |||
list of network computers | Excel Programming |