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)

"Rob Edwards" wrote in message
...
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!

*** Sent via Developersdex http://www.developersdex.com ***