Macro Recording and Saving.
 

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.

Macro Recording and Saving.
 

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

Macro Recording and Saving.
 

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