How to set file path (including tab reference)

Hello everyone,

I want to create a sheet where one can enter data and that would have a macro that copies the entered data into another workbook. The destination workbook will be in another folder that the source workbbok, and contains multiple tabs that can all be potential destinations. How can I set this workbook to something easier.

I.e. the same thing as this:

Please Login or Register  to view this content.

But that references outside the active workbook.

Thanks you for any help,

Corentin

Within VBA, you would set a WB object, then fill that object with the workbook name as you open it. Then throughout your macro, you continue to refer to that workbook by the WB variable you declared.

Please Login or Register  to view this content.