ASP.NET

Problems with dynamic Excel with Module

Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2009

Posts: 1

Reputation: Jojo1974 is an unknown quantity at this point

Solved Threads: 0

Jojo1974

Offline

Newbie Poster

Problems with dynamic Excel with Module

Oct 30th, 2009

Hi, I am hoping someone can help with a problem I am having

I am using ASP (VB).Net 2003 on Windows Server 2003 and I am trying to create a web application which dynamically creates an excel spreadsheet which has a module included. When I run this on the local host it works fine but once I load it onto the server I get the following error message

HRESULT = 0x800A17B4 "Programmatic Access to Visual Basic Project is not trusted

I am using the following VB.Net code
Code:

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
Dim xlmodule As Object 'VBComponent
xlmodule = xlbook.VBProject.VBComponents.Import(PathToImport & "Module1.bas")
 
Dim xlmodule As Object 'VBComponent
xlmodule = xlbook.VBProject.VBComponents.Import(PathToImport & "Module1.bas")

If I turn off the code then it will load the spreadsheet without the module but the module is the critical part of the spreadsheet.

I have tried changing permissions but this is running on a client and not a physical machine. I am populating on the server in Excel 97 to avoid microsofts security issues

Does anyone have any ideas?

Regards

Jo

Last edited by peter_budo; Oct 31st, 2009 at 1:28 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)