save Excel file

  [DELETED] 16:20 02 Aug 2003
Locked

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

  [DELETED] 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.

  [DELETED] 16:30 02 Aug 2003

how about a bat file

  [DELETED] 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

  [DELETED] 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

Microsoft Surface Book 2 15in review

Iglooghost's hyper new music video gives a mutant take on Monument Valley

The best Amazon Prime Day Apple deals 2018

Comment ajouter de la musique à une présentation Google Slides ?