VB Net 2003 Excel Module problems

[jojo1974]

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

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.

Does anyone have any ideas?

Regards

Jo

[Hack]

This is a Macro Security setting (macro virus protection) and you cannot change it programmatically.

If this is a Server-Side action, then the Server this is running on can have this setting changed manually via Alt|Tools|Options... then the 'Security' Tab, then the <Macro Security> button, then the 'Trusted Publishers' Tab. At the bottom of that Tab you will see a checkbox named 'Trust access to Visual Basic Project'. You must make sure that checkbox is checked.

However, if this is a routine that is to run on the client side, it won't run unless this "Trust access to Visual Basic Project" is also turned on manually.

This may require your clients having to lower their macro protection. Asking them to do that is not very nice and most probably won't.

Hopefully, however, this routine is Server-Side which would mean it is within your control.

You might want to have a read of some of the caveats discussed here:

Server-Side Automation of Office