VBA Project Reference coping to other workbooks

[realniceguy5000]

Hello everyone,

Could someone advise me how to copy a reference from one workbook to another?

I have a template workbook/worksheet that I use to create around 52 workbooks for each week of the year. However the template workbook has a reference to another workbook that I need to copy as well. Anyway of doing that? It makes no difference to me if I need to recreate the workbooks again or work with the workbooks that have already been created.


Let me know if you need more information.

Thanks as always for the help.
Mike

[royUK]

What reference do you mean?

Why do you need a separate workbook for each week?

[realniceguy5000]

What reference do you mean?

Why do you need a separate workbook for each week?

Hi Roy, Been a while...

When I open the vba project where you can look at the modules.(ALT-F11)
Under Modules it list the References.

Like I said this is a template workbook with one worksheet that is setup the way I want all the others to look like. What I do is make copies of the template sheet and it becomes a new workbook. Each week the user will open the corresponding weeks sheet and enter all the order numbers and a bunch more data for the week. After I make all the copies I need to add a couple of mods to each of the workbooks. All that works fine. It;s only this reference I'm having troubles moving or making, I really dont want to have to go into each workbook and create the reference.

Hope that helps a little,Any Idea's?

Thank You, Mike