LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Excel 2007 on a network where some computers have Office 200 CliffsClimb Excel Worksheet Functions 0 March 18th 08 02:46 PM
After Excel 2007 install, cannot save files on network share cbass Excel Discussion (Misc queries) 0 June 15th 07 09:57 PM
opening same file on 2 computers simultaneously with excel 2007 Zoe B Excel Discussion (Misc queries) 1 June 1st 07 03:02 AM
Can I send files from Excel 2007 to computers using Excel 2003? George Excel Discussion (Misc queries) 1 February 19th 07 08:14 PM
list of network computers dreamer[_9_] Excel Programming 3 February 14th 04 11:13 AM


All times are GMT +1. The time now is 08:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"