View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Philosophaie Philosophaie is offline
external usenet poster
 
Posts: 110
Default 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?