[HELP] About Export excel with vb.net

[Jonathan Tong]

Hi Everyone,

I have wrote a application which using vb.net, i part of problem is if i
export the excel from my PC it will pop up a warning message.
The warning message is
"HRESULT 0x800A03EC"

Anyone knows how to solve it?
Best Regards,

Jonathan Tong

 

[rawCoder]

Hi Jonathan,

Very difficult to judge just by error code.
But after a little googling there is something i found out.
One thing that u may do ( besides posting the problematic code is pass
System.Reflection.Missing.Value instead of NULL in open or saveAs method -
IF you are using one.

HTH
rawCoder

 

[KC]

Basically it means your trying to do something in Excel that cannot be done.
I know that doesn't help (I get the error all the time), but it points
generally to your problem.

Sites that may help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;306022

http://support.microsoft.com/?scid=kb;EN-US;301982

I just started getting into the whole Excel from VB.net thing and I'm still
looking for some non-trivial info on the subject.

Ken