Problems manipulate excel2003 via .net

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have used the VS2005 imigration wizard to imigrate a VB6.0 project that:
- Build dynamic workbook by the xml, and save it as "myExcel.xls"
- Manipulate it via automation

It all used to work fine in vb6.0

1)The VB6.0 classes have used msxml dom objects and were converted to interop
But Now the xml lines are to long(before they were broked down)the
2) After the file is created I ask for some values, If the cell value is
extracted from an escel function it will give an error value(#NA). Of course
the automation classes were converted to interop as well

Any idea?
 
From what I have read, the Migration Wizard from VB6 to .Net is somewhat
limited in ability.
- Do not expect it to convert everything.
- Do expect to have to check every line of code and correct/re-write.

NickHK
 
Back
Top