Hi, I wanted to put a copy of an Excel file on another drive and want that if I modify the original file, the copy should be updated as well. Can somebody help me on that? Many Thanks in Advance! Linux is basically a very simple Operating System, but you have to be a genius to understand its simplicity. http://www.cyberscout.net/

On occasion, I need to save a file in 2 locations so I wrote a "dual save" macro which essentially pops up the Save As dialog box twice. The first time it saves it in the default location, the second time I choose a different location, such as a USB drive. This ensures that I always save an exact copy of the file. I assigned the macro to a button right next to the Save icon on my toolbar and use it whenever I want to perform a "dual save". You could take this one step further and hardcode both locations into the macro, so that it would save the file in both places automatically with one click. Here's the code that pops up the dialog boxes. Sub DualSave() ' ' DualSave Macro ' 'Get Filename, Default = FileName fileSaveName = Application.GetSaveAsFilename() 'Save File to Chosen Location If fileSaveName <> False Then ActiveWorkbook.SaveAs Filename:=fileSaveName End If 'Do it again fileSaveName = Application.GetSaveAsFilename() If fileSaveName <> False Then ActiveWorkbook.SaveAs Filename:=fileSaveName End If End Sub