Create/use server-side OWC11 SS Component

J

jjintx

My development environment is VS2003.NET under WinXP Pro. I have local
installation of OWC10/11 located in the GAC. My ASP.NET OWC-based app runs
fine on my local machine.

When I try to port to Win2000Server for deployment, I copy
Microsoft.Office.Interop.Owc11.dll and its supporting .dlls locally and use a
codebase tag so the runtime can find the assemblies.

It works until it attempts to use a filter function, specifically

objSS.Worksheets("Sheet1").Autofilter.Filters(x).Criteria.Add(strCostCenter)

and then it throws a "bad variable type" exception.

How can I resolve this problem.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top