Linking a workbook to my workbook

Dear experts

I would like to create a macro in order to link my workbook with another workbook. Ideally, when i run this macro i would like the sheets of the linked workbook to appear in my workbook. Do you think it is possible? I would highly appreciate your contribution.



I am looking forward to your response.

Best Regards\

Hi !

If you want a link you have to use the classic cells formulas.

Or you can just create a procedure to apply a copy as you can activate the Macro Recorder
and operate manually in order to get your own base of code …

Thnx for your fast response.

My only problem is that i want to create this procedure in order to validate some numbers. When another user adds his/her own file to the existing workbook i would like this procedure to be the same from another pc.