Save to hard drive and backup to thumb drive.

J

Jef Gorbach

sounds like you already have a macro saving the file to someplace(?), so
merely duplicate that code changing the destination to your thumbdrive so
pressing the button saves it both places.
 
S

sungen99

Jef I do that is correct. What I will do is simpally do the following:

Save to c:
Save to f:
Save to x:

My question is this however. If you are at home the f drive save will
fail as there is no f drive. My question would be how to tell the
macro that if there is an error for it to keep going?

What would be really nice is a pop up message saying:

“File is backed up and saved on your Home Drive”
or
“File is backed up and saved on your Work Drive”

That would be really cool.
 
S

sungen99

Is it possible to turn off errors in macros???

I think the best way to accomplish what I need to do is to save the
file on both locations. When the macro runs it is going to error out
on one of the attempts to save but if I can some how turn off that
function it will automatically save. This way there is no need to ask
the user if he is at home or at work.

Again, my programming ability is limited to hacking existing code and
my searching the forums has not turned up anything like this.

Thanks again for your help with this. It is much appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top