How do I reference a workbook using a codename?

[toddot04]

So here is my problem. I have 2 open workbooks. I need to copy a set of cells and paste it to a sheet in another workbook. I have to be able to reference the code-name because the file name is always changing because of users needing to update it.

Also in the best case I would like to be able to have it look into only the open workbooks because more then likely their will be lots of the same codename because of identical wb from other jobs on someone computer.

So as it stands I have:

DRun.ActiveSheet.Range("A4:k7").copy
Activewb("MR").Inventory.Range("A3").paste

Always comes back with an error.

I have no idea how to get this to work. New here and going crazy.

 

[toddot04]

They are just right clicking the file and changing the name at the end of each job. Such as XY-Run#1.xls, then copy that file and rename it to XY-Run#2.xls
The inventory in the new Run file is what I'm trying to copy to the Inventory tab inside the Morning Report workbook (codename, MR).

This line "Update at the Start of Each Run from Run Report" in the wb MR.inventory is unique the that open workbook/tab.

Also something shorter is "v.2.04" i can hide that. its in h12 cell.

 

[mikerickson]

They are changing the name of the file.
If you look at a file, how do you know if it is the one that you are looking for?

 

[toddot04]

The file would have "Morning Report" somewhere in the file name.

 

[mikerickson]

A "file" is a file on a computer, it might be an Excel file or a Word file or ...
A "Workbook" is an Excel object
A "worksheet" is a single worksheet, there can be many worksheets in a Workbook.

Are you talking about files or worksheets. Your use of codename suggests that you are talking about worksheets.


If the user is changing file names, how can you be sure that "Morning Report" is part of the name they change it to?

If you are having trouble with users doing things that you don't want (like changing file names) that is an training/HR issue that Excel is not competent to address.

 

[toddot04]

I really want to thank you for taking the time to help me out. On this thread I think I'm just not communicating my needs to you. But I did a work around and its almost working. I started a new thread addressing it. Maybe you can take a look at it and hopefully see what I'm trying to do.

http://www.mrexcel.com/forum/excel-questions/865867-help-making-code-work.html#post4204481