Excel VBA reference cell on worksheet for file pathway

Hello,
I am needing to reference cell J2 on the “Data” worksheet for the file pathway in the below macro. How can I accomplish that? My goal is to have a concatenate in J2 on the “Data” sheet and reference this cell as the file pathway for the macro. That way I can easily change the 12.17 part each month within the spreadsheet and not have to go into VBA and change every month.

Please Login or Register  to view this content.

Thanks!

Perfect, thank you! I would add reputation but it is saying I need to "spread it around" error.. Marked as solved. Thanks again!