How to Activate Open Workbook

[Guest]

I have a macro using two Workbooks. I am appending the sheets from the Trans workbook to the same sheets in the Master workbook.

I open the Master workbook and run the Macro from it.

I open the trans workbook with the following:

myFile = Application.GetOpenFilename("Excel files,*.xls")
Workbooks.Open Filename:=myFile

I then select the sheet, copy the data, Activate the masterfile with the following

Windows("Masterfile.xls").Activate

I select the sheet, paste the data at the end.

The problem I have is when I want to Activate the trans file to work on the next sheet, I get an error when I say:

Windows("myFile").Activate

Also error with:

Windows(myFile).Activate


How can I Activate this workbook.

Thanks for help.

I select

 

[Rollin_Again]

Try using:


WORKBOOKS(MYFILE).ACTIVAT



Rolli