Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can macros include page setup functions? | Excel Discussion (Misc queries) | |||
Excel Add In Deployment | Excel Discussion (Misc queries) | |||
MACROS SETUP | Excel Discussion (Misc queries) | |||
App using OWC 2003 Deployment - How to ? | Excel Programming | |||
Deployment question | Excel Programming |