Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation confusion | Excel Discussion (Misc queries) | |||
MDI Confusion | Excel Discussion (Misc queries) | |||
Confusion..... | Excel Discussion (Misc queries) | |||
drop-down confusion | Excel Discussion (Misc queries) | |||
Sheet Name Confusion | Excel Programming |