Referencing an Opened Workbook (with variable in file name)

[yyRain]

What I am trying to do:
1) Have user enter date, make the date a part of the file name and open that file.
2) Once the file is opened, look at each tab, find due dates within 7 days, and copy the data to the corresponding "5 days lookahead" workbook.

Please Login or Register  to view this content.

[Norie]

You could add a variable that references the workbook being opened.

For example, I've added the variable wbToday to this code and set it to refer to the workbook being opened.

You can now use wbToday in any subsequent code when you want to refer to that workbook.

Please Login or Register  to view this content.

[yyRain]

Norie, thank you for replying.

The Workbook with the date has been opened. What I want to do is to go to this workbook, copy some data.
Then go back to the workbook (5 days lookahead) and paste it. Then go back and forth.

My codings are:

Please Login or Register  to view this content.

[Norie]

You can't select a workbook and a sheet in that workbook at the same time.

Mind you, there's no need to select/activate anything to copy/paste.

What range do you want to copy from Sheet1 of the workbook that's been opened?

[yyRain]

It's actually more complicated:

1) So now my working workbook (5days lookahead) and my data workbook (Airframe Daily with date variable) are opened.
2) I want to go to Daily, tab Tier 2 to find out how many rows of data I have.
3) Then for anything with 3rd column with a date less than now() =7, I want to copy that row
4) Then go to the 5 days workbook, Tier 2 tab, and paste that row to the row after the last record.

Please Login or Register  to view this content.

[Norie]

Doesn't sound too complicated.

Mind you all that, unneeded, selecting/activating does kind of make the code look complicated.