Is there anyway to restore a workbook?

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

 

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

 

[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