Macros setup deployment

[Thierry Paradis]

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.

 

[Norman Jones]

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

 

[Jo]

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

 

[Pete_UK]

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

 

[Jo]

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.

Sure does... thanks a lot, Pete

 

[Pete_UK]

Thanks for the feedback, Jo.

Pete