Workbook focus when opened by another workbook

[wrobs]

I am trying to copy data from one workbook (Sheet1) to another Workbook (sheet specified by cell value) in this particular way...
I have a macro that opens a *.dat file in workbook1. In Workbook(1) I have a cell (Value is "May") that I want to use as a means to open worksheet 'May" in workbook2 and then copy Workbook1 (sheet1) to workbook2 (Sheet "May") I can successfully open Workbook2 but when I try to "find" Sheet (May) in WB2 by using sheet.count in a For...Next loop It counts in WB1 sheet(1). Any suggestions??

Oh, and before someone asks the obvious... I have to do it this way because I'm getting data from a device that has a hardcoded excel file to get the *.dat data to excel and this is workbook1.

Any ideas would be appreciated.

Robert

[MarMo]

hi ,

If you're familiar with VBA you could work with variables to define your workbooks

Please Login or Register  to view this content.

and then you can get the workbook you need to be active .

Hope this helps.