View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pete pete is offline
external usenet poster
 
Posts: 88
Default VB.NET and Excel Range data

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