Creating Macros at runtime

  • Thread starter Thread starter Rob Edwards
  • Start date Start date
R

Rob Edwards

Hi,
I have a macro that creates a seperate workbook from info
provided. This is saved as a different filename each time. No problem
here!

What I want to do is "attach" some simple macros (i.e. sort etc) to
the this newly created workbook. Can I either create a new macro from a
source one or alternatively just simply copy an existing macro to a new
workbook?

Please advise.

Rob Edwards.

Always look on the bright side of life!
 
I would create the new workbook from a template workbook that already has
the code in it.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 

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

code to attach a macro to a newly created worksheet 2
run macro in another workbook - error 1004 7
macro free workbook saves macro 0
Create new workbook and move the Macro without reference to old wb 1
path to macros being changed 6
Macro - New Workbook 1
copying code from personal folder 1
Buttons re-assigned themselves to the right macro name but in Book 1

Back
Top