Macro Recording and Saving.

[SITCFanTN]

I'd like advice on the best way to save a group of macros for a specific
report on about 8 separate PC's used by 8 separate people. Each of these
folks will need to run this report on a daily basis. I was thinking using
the Personal workbook might not be best because if I have to edit the macros
for one reason, I would have to do it on all 8 PC's right.....I'm new at this
so any advice you can give is certainly appreciated. Thank you.

[Norman Jones]

Hi SitCFanTN,

I would suggest that you save the macros in an add-in and distribute the
addin.

See Jan Karel Pieterse's excellent tutorial at:

http://www.jkp-ads.com/Articles/DistributeMacro00.htm

The tutorial also includes an installation programme, which you can see in
operation by downloading any of JKP's add-ins (free of charge) from:

http://www.jkp-ads.com/Download.asp


---
Regards,
Norman


"SITCFanTN" <SITCFanTN@discussions.microsoft.com> wrote in message
news:B7A9BCF5-6E89-46A0-B9E0-799005BE6EC6@microsoft.com...
> I'd like advice on the best way to save a group of macros for a specific
> report on about 8 separate PC's used by 8 separate people. Each of these
> folks will need to run this report on a daily basis. I was thinking using
> the Personal workbook might not be best because if I have to edit the
> macros
> for one reason, I would have to do it on all 8 PC's right.....I'm new at
> this
> so any advice you can give is certainly appreciated. Thank you.

[SITCFanTN]

This site is awesome, thanks so much for passing it on to me! Have a great
day!

"Norman Jones" wrote:

> Hi SitCFanTN,
>
> I would suggest that you save the macros in an add-in and distribute the
> addin.
>
> See Jan Karel Pieterse's excellent tutorial at:
>
> http://www.jkp-ads.com/Articles/DistributeMacro00.htm
>
> The tutorial also includes an installation programme, which you can see in
> operation by downloading any of JKP's add-ins (free of charge) from:
>
> http://www.jkp-ads.com/Download.asp
>
>
> ---
> Regards,
> Norman
>
>
> "SITCFanTN" <SITCFanTN@discussions.microsoft.com> wrote in message
> news:B7A9BCF5-6E89-46A0-B9E0-799005BE6EC6@microsoft.com...
> > I'd like advice on the best way to save a group of macros for a specific
> > report on about 8 separate PC's used by 8 separate people. Each of these
> > folks will need to run this report on a daily basis. I was thinking using
> > the Personal workbook might not be best because if I have to edit the
> > macros
> > for one reason, I would have to do it on all 8 PC's right.....I'm new at
> > this
> > so any advice you can give is certainly appreciated. Thank you.
>
>
>