Member Avatar for Jojo1974
Jojo1974 0 Newbie Poster

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:

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

Edited by peter_budo because: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)
  • 1 Contributor
  • 0 Replies
  • 72 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.