?
Solved

? Suppress Microsoft Security alerts when automating in visio:  OpenEx(path\myfilename.vss)

Posted on 2011-09-18
3
Medium Priority
?
749 Views
Last Modified: 2012-06-27
Hi, I am automating a visio procedure which includes:

Set docRuleStencil = Visio.Documents.OpenEx(myPath\myFilenane ".vss", visOpenDocked + visOpenCopy)

This line --> security alert notice "enable or disable macro"s, andh cites the filepath above.

I think I'd like to suppress this message because I know the .vss file I'm calling, and I dont want the user worried by warnings. I'd like to turn the warning back on when the .vss has been opened.

Is this approach good practice for an application that is to be used by several/many people, not all under my control? ... and how do I  effect it in my VBA procedure?

Thanks
Kelvin4
0
Comment
Question by:Kelvin4
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 13

Accepted Solution

by:
khairil earned 1800 total points
ID: 36556738
Hi,

If your use run on Active Directory, you can turn off security option for Microsoft Office product using group policy, http://technet.microsoft.com/en-us/library/ff400327.aspx

Other way you have to configure every client computer to allow access on VBA macro, http://office.microsoft.com/en-us/visio-help/enable-or-disable-macros-in-office-documents-HA010031071.aspx

The best way is, if you have valid certificate from CA then use it, your VBA apps will have no problem with MS Office security anymore. GoDaddy have cheaper cert compare to other, http://www.godaddy.com/ssl/code-signing-certificate.aspx?ci=13314 but you are free to find much more lower price tag, but be sure they support Code Signing.

If you like to generate you own cert to sign the document then follow this article, http://stackoverflow.com/questions/84847/how-do-i-create-a-self-signed-certificate-for-code-signing-on-windows

Then import the pfx file generated using above article to other computer to trust your cert. Personally I not trying it yet, but by experience with SSL Cert (SSL cert is different compare to Code Signing Cert) it can be done.
0
 
LVL 11

Assisted Solution

by:Visio_Guy
Visio_Guy earned 200 total points
ID: 36559284
Hi Kelvin,

Sounds like the stencil you are opening has VBA macros in it. Do you want them to be available? If not, you could use the visOpenMacrosDisabled flag with OpenEx and avoid the warnings.
0
 

Author Closing Comment

by:Kelvin4
ID: 36566002
Hi khairil and Visio Guy:

Thanks for giving me a good view of this issue.
khairi: Just what I needed!
visio guy: Good to know about the openEx flag. The shapes on the Stencil I was calling provide shapesheet data to subsequent macro procedures, but do not themselves CALL any procedures. Nonetheless, the flags stopped all my current macros, so that option is closed to me.
Best regards,
Kelvin
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question