Object variable or with block variable not set
Someone please help me!!! My project deadline is nearing and
my excel vba has just stopped working.
I have created a vb6 dll which creates a excel chart (using excel 2000). This dll is then called from asp.net. Was getting the error "Object variable or with block variable not set". Had to change excel settings(using dcomcnfg) to make things work. The chart was getting created beautifully. No issues at all. Now i use the same dll on windows 2003. And i get the same error back!
Have spent 2-3 days doing research on this. But got no pointers.
Anyone who can help????