Excel VBA reference cell in worksheet for workbook to open

[Hoover5896]

Hello,

Can someone please help with the last question on the below forum link?

https://www.excelforum.com/excel-pro...-pathways.html

I am wondering if I can make it so the workbook names can be referenced in column F too, so I do not need to go into VBA and type each workbook name anytime there is an update and can just do so in column F?

Please Login or Register  to view this content.

I tried a few variations of below.

Please Login or Register  to view this content.

[sintek]

Hi Hoover5896
Something like this perhaps...

Please Login or Register  to view this content.

[Hoover5896]

I tried:

Please Login or Register  to view this content.

but I am getting an error. I attached the workbook for reference. I am trying to get the macro to reference F2 and downwards as the Excel file name for it to go into and pull the sum of column C divided by 2 on the Trial Balance worksheet.

[JOHN H. DAVIS]

Two things I noticed in glancing at your code. You have what appears too be an unnecessary "Next" towards the center of your code. The values in Column F appear as you state to be workbooks, but you define wbnames as worksheets?

[Hoover5896]

I tried fixing that but I still receive the same Run-time error '424' object required. It looks like it is failing at:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

I think you have to:

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

I don't see in your code where you are opening any workbooks. Is that your intention? Or will they already be open?

[Hoover5896]

Someone else has made this code actually so I am not too familiar with it, but the workbooks will be closed and not open.

Currently my workbook macro is as follows and pulls the workbook data as needed, but I would like the macro to reference column F2 and down for workbook names instead of having to type them into the macro.

Please Login or Register  to view this content.

Similar to how this macro is pulling the pathway names from G2 and down so I do not have to have the pathways defined in the macro. This way I can easily manipulate the cells (workbook names in F2 and down, and file pathways in G2 and down without having to go into VBA).

Please Login or Register  to view this content.