Is there anyway to restore a workbook?
 

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.

Is there anyway to restore a workbook?
 

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" wrote in message
...
Harald

don't tease ? <g

Tim

"Harald Staff" wrote in message
...
Everything is possible with VBA. But it needs some clever programming.

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.

"Bin" wrote in message
...
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.

Is there anyway to restore a workbook?
 

Harald

that's true!

Bin

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

hth (a bit!)

Tim




"Harald Staff" wrote in message
...
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" wrote in message
...
Harald

don't tease ? <g

Tim

"Harald Staff" wrote in message
...
Everything is possible with VBA. But it needs some clever programming.

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.

"Bin" wrote in message
...
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.