Workbook setting incorrectly VBA

[LRoy]

I'm trying to set two different workbooks so that VBA can distinguish between the two.

I have named one CurrentWB which is the workbook I'm currently using and creating the Sub for, and the other ComponentWB which is the workbook I intend to extract data from.

I have set CurrentWB as ThisWorkbook and have set ComponentWB as "Component Data.xlsx", which is the name of the component workbook.

However, when I step through the code it keeps setting ComponentWB as ThisWorkbook also. Does anyone have any ideas why?

The ComponentWB is not the workbook I am writing the code in so I'm unsure why it is setting as ThisWorkbook, especially when I have told it to set to "Component Data.xlsx"

Any help would be appreciated,
Thank you

 

[Fluff]

I suspect that it is setting the ComponentWB correctly, you are just not using it, neither are you using CurrentWS

 

[LRoy]

I suspect that it is setting the ComponentWB correctly, you are just not using it, neither are you using CurrentWS

Hi Fluff, thank you for your reply. Do you mind elaborating please? If I'm telling VB to set the ComponentWB to a specific file name, why is it setting it to ThisWorkbook? I have the file open and I want to refer to it in the code, but currently I'm unable to as I can't set it properly.

 

[Fluff]

If you expand the ComponentWB & look for the workbook name you will probably find that it is setting it to the correct workbook.

 

[LRoy]

If you expand the ComponentWB & look for the workbook name you will probably find that it is setting it to the correct workbook.

You're right it is. Because CurrentWB and ComponentWB were showing as the same thing under 'Type' I thought VB was viewing them as the same workbook. Thanks for clearing that up for me!

 

[Fluff]

You're welcome & thanks for the feedback.