Excel files

[keithg]

Is it possible in Excel 2007 to save a file in multiple locations with one mouse click.

I need to save it to the desktop then to a separate hard drive as a backup and a memory stick for use on my laptop.

As it now I have do to it as three separate operations.

Thanks

Keithg

[boxtops]

I'd be interested too, as I "save as" twice for a number of my operations - hard drive and memory stick

[Vagrant]

No.
There are ways to achieve the end result - for example, schedule a timed job to copy everything on your desktop to 2 other locations.

[TTG]

Create a Macro. Tools, Macro, Record New Macro. When recording, do a "Save As" command and select each location in turn. Stop Macro.

When you run the Macro, you will be prompted to overwrite each saved spreadsheet. You could create a button to run the Macro. You might be able to create some vba code to run the Macro on closing the spreadsheet. Sorry, pushed for time so this is all I can give you!

[keithg]

Thanks TTG

I have created a macro , not easy for somebody with little knowledge of Excel, now I can save the file in various locations, not with one but a few clicks, much easier than how I was doing it before.

I asked Google how to create a macro.

Boxtops it can be done not quite as we wanted but close enough

Thanks again.