Move a workbook to another network drive, without Open/Save As...

[SQLBI]

Hi,

Currently i'm transfering MS Excel 2000 files from one network folder to another, using Workbooks.Open and Workbooks.SaveAs

Is there a way of copying and saving a workbook, without opening and saving?

Thanks in advance.

Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[michaelbr55]

object.CopyFile source, destination[, overwrite]

eg. FileSystemObject.CopyFile "c:\mydocuments\letters\*.doc", "c:\tempfolder\"


look in the VB help file for more info.

Mike

 

[Molby]

You can use the below:

Name "C:\folder1\name.xls" As "c:\folder2\name.xls"

Regards,

Ian

 

[SQLBI]

Guys,

Sorry, but i omitted one important factor from my original post... These files start up not being protected, however when they're transferred, a password to open the workbook is applied...

Does this affect your earlier responses?



Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[Molby]

Yep, I'm afraid mine wont work!!

 

[IvanMoala]

None of them will work.
You will need to open them and save as with your File protection settings.