[douggerlach]

hello,
i am using vb 6 to write an app that opens multiple excel spreedsheets and pull data from those spreedsheets. I need to know the code line for switching between the multiple workbooks and pages once they are all opened.

can anyone help with this?
thanks
doug

[B3gbie]

Why not do this within Excel using VBA? The functionality is slightly reduced as far as VB is concerned, but you already have all the Excel functions at hand in the object browser.

[Kelly_in_LA]

Is something like this what you are looking for?


Windows("Book1").Activate
Windows("Book2").Activate
Sheets("Sheet2").Select


Also, you do not need to activate a particular workbook in order to obtain information from or about it. You can call on that workbook and its properties and methods without activating the workbook.

For example, if "Book1" is the active (visible, "on top") workbook, then something like:

MsgBox Workbooks("Book2").Worksheets("Sheet1").Cells(1, 1)

...will still work just fine even though "Book2" is not the active workbook.


Hope that helps!
-Kelly

http://kellyjones.netfirms.com/dictionary.html

[Kelly_in_LA]

Of course, from VB6, I believe you have to add "Excel" to everything, such as:

Excel.Windows("Book1").Activate
Excel.Windows("Book2").Activate
Excel.Sheets("Sheet2").Select

Am I right about that? I'm not the leading expert on VB6 by any means. But I definitely know VBA for Excel.

Perhaps someone can clarify whether:

Excel.Windows("Book1").Activate

is appropriate and correct for what you are asking.

Best of luck!