Using a macro to create a macro in another workbook

G

Gizmo63

You're right Bernie - as soon as it starts to insert the code Excel crashes.

Does anyone have any other suggestions?
 
B

Bernie Deitrick

Gizmo,

The better way to do it is to have a template with all the code in it already, open the template,
copy the worksheets over from the existing workbook, kill the existing workbook, and save the
template with the original workbook's name. Keeps Excel from crashing.

Let us know if you need help with the code.

HTH,
Bernie
MS Excel MVP
 
G

Gizmo63

Thanks Bernie, but I'll be fine with coding that.

Had hoped for a nice 'enclosed' solution but hey, can't have everything!?!

Cheers anyway

Giz
 
Top