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