Enabling macros

in reply to Re: Reading from Excel
in thread Reading from Excel

Hi -

I am working with hrvoje on this. Our spreadsheet does need enabling of macros. If we run the spreadsheet from MS Excel on desktop, it asks for enabling of macros in a pop-up. Is there any way that all macros in the spreadsheet can be enabled to run programmatically ??

Thanks and regards
migs

Comment on Enabling macros

Replies are listed 'Best First'.
Re: Enabling macros by cacharbe (Curate) on Aug 10, 2002 at 22:35 UTC
You'll need set the security settings in the application to "Low" so that they will run on the machine that your script is running. You can't do this programmatically that I have found, but that just makes sense (for obvious reasons). You can do this by going to the toolbar and following: `Tools->Marco->Security...` *Update and Caveat:* This isn't a safe mode to run Excel if this machine is used for anything other than application level access to Excel. You should always implement a strong anti-virus scheme and limit access to machines that need to run in this mode. Audit early, sudit often. C-. --- Flex the Geek	[reply] [d/l]
Re^2: Enabling macros by Anonymous Monk on Mar 31, 2008 at 14:49 UTC
Has there been an update to this to be able to programmatically? My issue is disabling macros because the OLE for opening the book,that has macros, gets "hung up."	[reply]

In Section Seekers of Perl Wisdom