Using a macro to create a macro in another workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Does anyone have any other suggestions?
 
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
 
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
 
You must log in or register to reply here.

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

Similar Threads

move worksheet to end of another workbook 3
macros 5
Macros 7
Macros 1
create personal macro workbook 3
Excel TWO Instances of Excel One watching Other 3
Excel Protection 2
Macro code behind button 1

Back
Top