Greetings, How exactly are you opening the spreadsheet? The only way to close those windows if they are "created" by something a script did, is to have another script that watches for the window and closes it.
If this is Excel 2007, I'd suggest going into Excel's Trust Center and turning off the security so the window doesn't appear anymore. I got the below window by clicking the new "big button that indicates file menu J" selecting Excel Options button - then Trust Center - then Trust Center Settings. In previous versions it was I think under the Macros menu option - things were easier back then I suppose. I've successfully run macros after having done that using the DataStation D.open "excel file.xls",ftExcel D.t.appl.Run "macro name",optional param1, 2' You get up to 30 parameters. Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com <http://www.bossoft.com/> Sign up for my weekly webinar! <http://www.bostonworkstation.com/customer_center/special_events.aspx> LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately, then delete this message and empty from your trash. From: [email protected] [mailto:[email protected]] Sent: Friday, September 25, 2009 1:13 PM To: Talk Subject: [talkbws] Excel Security Warning window I can't seem to respond to MS Excel's "Security Warning" window when connecting to a spreadsheet that contains macros. All I want to do is open the spreadsheet, enable macros, launch a particular macro, then save and exit but I'm stuck at the "warning" window for macros. In fact I can't even pause the script until I manually respond to it. Any idea's? Thanks, Stephen Breitenbach, MT(ASCP) Applications Analyst St. Joseph Medical Center 7601 Osler Drive Towson, MD 21204 phone (410) 337-1948 FAX (410) 427-5432 cell (443) 468-0555 CONFIDENTIALITY NOTICE: This message contains information that may be confidential and privileged. Unless you are the intended addressee (or authorized to receive for the intended addressee), you may not use, copy, or disclose to anyone the message or any information contained in the message. If you have received the message in error, please advise the sender by reply e-mail and delete the message. --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk .aspx
<<image001.png>>
