Is there anyway to restore a workbook?

B

Bin

Is there anyway to restore a workbook?
I want to put ths function in Error Handling code. If
there is anything wrong, just restore the workbook.
 
H

Harald Staff

Hi Tim

It's impossible to go into detail unless we know "restore from what".

"Throw this one in the can and load my last backup instead" should cover most instances
though.

Best wishes Harald
Excel MVP

Followup to newsgroup only please.
 
T

Tim Childs

Harald

that's true!

Bin

you might want to look at the method:
ActiveWorkbook.SaveCopyAs
to get you started

hth (a bit!)

Tim
 
Top