Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: Enabling macros

by cacharbe (Curate)
on Aug 10, 2002 at 22:35 UTC ( #189236=note: print w/ replies, xml ) Need Help??


in reply to Enabling macros
in thread Reading from Excel

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


Comment on Re: Enabling macros
Download Code
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."

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://189236]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (4)
As of 2014-07-14 05:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (255 votes), past polls