Problems with dynamic Excel with Module

Expand Post »

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:

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)

Jojo1974

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Oct 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: Update INT type Checkbox Field

Next Thread in ASP.NET Forum Timeline: Debug

DaniWeb Message

Cancel Changes

User Name
Password