Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
nay nay is offline
external usenet poster
 
Posts: 4
Default Problems manipulate excel2003 via .net

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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Problems manipulate excel2003 via .net

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

"Nay" wrote in message
...
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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
manipulate data sjl Excel Worksheet Functions 1 May 3rd 06 01:55 PM
Possible to manipulate Legend? SiriS Charts and Charting in Excel 2 March 15th 06 12:47 PM
How to manipulate a row with a certain value Bill Excel Programming 4 February 24th 06 01:59 PM
manipulate string funkymonkUK[_74_] Excel Programming 1 October 11th 05 01:24 PM
Manipulate Excel Bich Leu Excel Programming 3 August 25th 03 11:57 PM


All times are GMT +1. The time now is 10:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"