Printable View
I am writing an application that needs to get input from an excel worksheet and out output to another spreadsheet in the same file. Using OLE Container Control, I was able to see the spreadsheet by using sourceData but I am not sure how to get the information stored in an individual cell. I tried sourceItem but that is not working. I must be doing something wrong, any help would be appreciated
Raj Morey:(
You need to make a reference to Microsoft Excel to your project. Then create this object.
If you have problem, I'll send you an article on how to use it.
Regards,
TheBao
Don't forget - there is a COM hierarchy in Excel. Three objects are required to access data at the cell level -
Excel.Application
Workbook
Worksheet
I have had problems doing some operations because I did not do a prerequisite method on a higher level object. Doh.
Most of the time now, I just turn on macro recording and do whatever it is I want to automate in Excel. Then I shut off recording the macro, edit the macro, and cut and paste the code into VB. Several times this has shown me some hierarchic steps I've neglected.
hth:)