Workbook focus when opened by another workbook

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

hi ,

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

Dim MyWb1 ' workbook 1
Dim myWb2 ' workbook 2


'asign the actual workbook to MyWb1

Mywb1 = Activeworkbook.Name

'Then if you open workbook2 asign Mywb2 to it

MyWb2 = Activeworkbook.Name


'To set the workbook active 

MyWb1.Activate

'or

MyWb2.Activate

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

Hope this helps.