processing excel spreadsheet with multiple worksheets
Posted on 2005-05-06
I have an excel spreadsheet that has two worksheets on it. Ultimately, my goal is to selectively pull values from both worksheets and combine them into the contents of a datawindow so I can save it to a database table and do some further processing. The data from worksheet one is combined with a given row on worksheet two by matching up two columns from worksheet 1 to worksheet 2.
I was planning on using excel oleobject to do a saveas to text so that I can utilize a datawindow but am unsure as to how to deal with the multiple worksheets.
Any thoughts on this? Maybe a saveas isn't the best approach. Possibly loop through the contents of each worksheet somehow?
Thanks in advance for your assistance.