Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
enabling macros from command line
I need to automate some Excel processing via macros so that a job can
just be scheduled to run without any user involvement. For this to work, macros have to be enabled. Unfortunately, I know of only one way to do this that doesn't involve interaction from the user - setting the security level to low. Is there any other way around this? Ideally, there would be a command line option that would enable macros but I haven't found anything. Setting the security level to low will obviously work but it's not a good solution. Any other possibility? Denis |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
enabling macros from command line
You cannot. Would you really want a program to be able to change the
security settings! The alternative is to create a digitally signed macros and /or set trusted sources -- Regards, Nigel "Denis" wrote in message ... I need to automate some Excel processing via macros so that a job can just be scheduled to run without any user involvement. For this to work, macros have to be enabled. Unfortunately, I know of only one way to do this that doesn't involve interaction from the user - setting the security level to low. Is there any other way around this? Ideally, there would be a command line option that would enable macros but I haven't found anything. Setting the security level to low will obviously work but it's not a good solution. Any other possibility? Denis |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
enabling macros from command line
Write a VBS (or other) script that creates an instance of Excel that then
opens your workbook. Macros in it will be enabled regardless of the user's security settings. You can have your code called from the Workbook Open event in the workbook or you can use RUN to execute the code. -- Jim "Denis" wrote in message ... |I need to automate some Excel processing via macros so that a job can | just be scheduled to run without any user involvement. For this to | work, macros have to be enabled. Unfortunately, I know of only one | way to do this that doesn't involve interaction from the user - | setting the security level to low. | | Is there any other way around this? Ideally, there would be a command | line option that would enable macros but I haven't found anything. | Setting the security level to low will obviously work but it's not a | good solution. Any other possibility? | | Denis |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
enabling macros from command line
Hi Jim
Do I remind this correct ? As far as I know you must enable the first VBS script you run on your computer one time (a msgbox I believe). -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jim Rech" wrote in message ... Write a VBS (or other) script that creates an instance of Excel that then opens your workbook. Macros in it will be enabled regardless of the user's security settings. You can have your code called from the Workbook Open event in the workbook or you can use RUN to execute the code. -- Jim "Denis" wrote in message ... |I need to automate some Excel processing via macros so that a job can | just be scheduled to run without any user involvement. For this to | work, macros have to be enabled. Unfortunately, I know of only one | way to do this that doesn't involve interaction from the user - | setting the security level to low. | | Is there any other way around this? Ideally, there would be a command | line option that would enable macros but I haven't found anything. | Setting the security level to low will obviously work but it's not a | good solution. Any other possibility? | | Denis |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
enabling macros from command line
On Nov 5, 11:58 am, "Jim Rech" wrote:
Write a VBS (or other) script that creates an instance of Excel that then opens your workbook. Macros in it will be enabled regardless of the user's security settings. You can have your code called from the Workbook Open event in the workbook or you can use RUN to execute the code. -- Jim"Denis" wrote in message Great. I just did a little test case opening a .xls with a Workbook_Open macro and it worked as advertised. Thanks a bunch. Denis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling Macros | Excel Worksheet Functions | |||
Running Macros from Command line | Excel Programming | |||
macros from command line | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Worksheet Functions | |||
command line excel to run macros | Excel Programming |