Macros setup deployment
 

Hi!

I have a Template (to place in the template folder) and a .xls file with
macros (to place in the XLStart folder) to deploy. Is it possible to deploy
thoses files with a setup.bat? The difficuly is to get the template and the
XLStart folders in a command line.

If it's not possible, which are the other ways to automatically install
those files?

Thanks for help,

Thierry Paradis.

Macros setup deployment
 

Hi Thierry,

See Jan Karel Pieterse's create an Addin tutorial which also includes a
set-up utilty:

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



---
Regards,
Norman


"Thierry Paradis" wrote in message
...
Hi!

I have a Template (to place in the template folder) and a .xls file with
macros (to place in the XLStart folder) to deploy. Is it possible to
deploy thoses files with a setup.bat? The difficuly is to get the template
and the XLStart folders in a command line.

If it's not possible, which are the other ways to automatically install
those files?

Thanks for help,

Thierry Paradis.

MACROS warning messages inhibition??
 

Hi,

I wrote a macro in which I delete sheets. On execution I get an
obnoxious warning message asking if I really want to do that. Of course
I do !!!!

Is it possible to prevent that kind of information warning from popping
up?

Thx in advance,
Jo


P.S. I'm still using EXCEL97

MACROS warning messages inhibition??
 

Just before you delete the sheet(s) add this line to your code:

Application.DisplayAlerts = False

then after you have deleted them add this line:

Application.DisplayAlerts = True

This will turn off the warning message for you.

Hope this helps.

Pete