save Excel file

  al 16:20 02 Aug 03
Locked

How can i save a excel file on two hard drives at the same time.

  Jester2K II 16:22 02 Aug 03

You can't at the same time.

Either save to one and then the other

or

Save to one then copy it to the other.

  al 16:30 02 Aug 03

how about a bat file

  VoG II 16:43 02 Aug 03

You could do this using a macro and you don't even need to know VBA. Just use Tools/Macros/Record new macro.

Here are the results of my efforts (save to HDD then FDD):

Sub Macro2()

ActiveWorkbook.SaveAs Filename:= "C:\Documents and Settings\Default\My Documents\Peter\excel\autonumber.xls", FileFormat:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False

ChDir "A:\"

ActiveWorkbook.SaveAs Filename:="A:\autonumber.xls", FileFormat:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False

End Sub

  al 16:52 02 Aug 03

Thanks VoG I will try this

This thread is now locked and can not be replied to.

iPhone 7 review: a range of small updates add up to an excellent phone

1995-2015: How technology has changed the world in 20 years

How New York’s Stylin’ Seniors became a golden social media campaign

23 Apple Watch tips & secret features: Master your Apple Watch, Apple Watch Series 1 or Apple…