ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Confusion with security (https://www.excelbanter.com/excel-programming/339536-confusion-security.html)

WhiskyFudge

Confusion with security
 
Background: I'm a ASP.net programmer. I've done a bit of win form stuff. A
single VBA access project. I've now got a new project which I'm determined to
do using .net.

I've installed the office VS add-in and can create a new project
successfully. This is where it all starts to fail. If I then debug the
project the excel file loads and disappears almost as quick. If I open up the
excel workbook on its own I get and error about the .net security policy not
being permitted.

Where do I go from here?

When I deploy this project to my client, what security issues may I face and
how do I work with them?

Tushar Mehta

Confusion with security
 
You may want to check out the book Professional Excel Development by
Bullen, Bovey, and Green. After reading its chapter on the subject,
I've decided to use managed add-ins only in limited cases.

You may also want to search msdn.microsoft.com on the subject.
Included in the hits I got for the keywords 'deploy vsto' (w/o the
quotes):

Lab 5: Deploying Office Documents that Use Managed Code Extensions
http://msdn.microsoft.com/library/de...l=/library/en-
us/odc_vsto2003_tr/html/odc_VSTMGBLab5.asp

and
Information about designing Office XP add-ins and Office 2003 add-ins
by using the .NET Framework
http://support.microsoft.com/default...b;en-us;840585
#XSLTH3140121122120121120120
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Background: I'm a ASP.net programmer. I've done a bit of win form stuff. A
single VBA access project. I've now got a new project which I'm determined to
do using .net.

I've installed the office VS add-in and can create a new project
successfully. This is where it all starts to fail. If I then debug the
project the excel file loads and disappears almost as quick. If I open up the
excel workbook on its own I get and error about the .net security policy not
being permitted.

Where do I go from here?

When I deploy this project to my client, what security issues may I face and
how do I work with them?


WhiskyFudge

Confusion with security
 
Thanks for your advice so far.

I started doing the lab as suggested with high hopes. However Exercise 1
Step 7: 'This time, the document opens without error, and the managed code
extension executes.' - No it doesn't! I still got the same error as befo

'The current .NET security policy does not permit My Work Bookmarks to run
from the folder .\My Work Bookmarks_bin\. Do Not change the security policy
in your computer. The .NET security policy is controlled by your
administrator or the developer who wrote the custom macros. You can still
edit and save the document. Contact your administrator or the author of this
document for further assistance.

Any advice?

I'm not determind to get some managed excel programming done, mostly because
I don't want to be beaten by it!

WhiskyFudge

Confusion with security
 
I have since worked out that this problem applies to my desktop only. My
laptop (recently reinstalled the OS) run's things with out a problems. I've
hunted around for differences between my desktop and laptop but not found
anything. Any ideas?


All times are GMT +1. The time now is 10:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com