save Excel file

  al 16:20 02 Aug 2003
Locked

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

  Jester2K II 16:22 02 Aug 2003

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 2003

how about a bat file

  VoG II 16:43 02 Aug 2003

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 2003

Thanks VoG I will try this

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

Elsewhere on IDG sites

iMac Pro review

Illustrator Charles Williams on how to create magazines and book covers

iMac Pro review

Les meilleures prises CPL (2018)