VB.NET and Excel Range data

P

Pete

I have a program written in VB6 that opens an Excel App;ication, selects a worksheet and reads the data from 6 Cols x 15 Rows. This data is placed into an array formated to type double and then VB6 performs some math calculations. No problem. I tried to convert this small program to VB.NET and the best I can get is an error message to the effect that the type Range cannot be converted to a type double. I have upgraded my Office XP with the necessary Interop according to Microsoft and have added the necessary references to my main program. I did have all of my Excel calling and reading routines in a module but now I'm trying to get away from a module situation. My 'not working code' can be provided if someone is willing to look at it

Thanks for anyones help

Pet
 
O

onedaywhen

Are you explicitly using the range's Value (or equivalent) property
i.e. something like

CDbl(Range("A1").Value)

rather than the sloppy

CDbl(Range("A1"))

This is a heads up for everyone out there who implicitly use the Range
object's default method. Always *explicitly* use the Value method,
otherwise it may trip you up one day!

--

Pete said:
I have a program written in VB6 that opens an Excel App;ication,
Click to expand...
selects a worksheet and reads the data from 6 Cols x 15 Rows. This
data is placed into an array formated to type double and then VB6
performs some math calculations. No problem. I tried to convert this
small program to VB.NET and the best I can get is an error message to
the effect that the type Range cannot be converted to a type double. I
have upgraded my Office XP with the necessary Interop according to
Microsoft and have added the necessary references to my main program.
I did have all of my Excel calling and reading routines in a module
but now I'm trying to get away from a module situation. My 'not
working code' can be provided if someone is willing to look at it.
 
Top