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 ***

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" <(E-Mail Removed)> wrote in message
news:uQTG$(E-Mail Removed)...
> 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 ***