VBA: Opening an external workbook based on a concatenated link (string) residing in a cell.

[Hawk11ns]

I have a workbook that's updated using data from several external workbooks. To create the links to these external workbooks I am using the concatenate function to concatenate both cell values (strings) and "text_strings". My macro is able to open these external workbooks, copy/past the necessary data, and close the external workbooks... BUT only when the links are hard coded. So I either need to have the VBA code perform the concatenation for each string OR have the VBA code recognize a concatenation formula result as a link to open the external workbooks. Suggestions?

 

[severynm]

What is an example of something you cannot open? I have no issues opening something like this

MrExcel.xlsm
	A
1	C:\Temp\
2	Slitting Schedule - 2 - 202101151
3	C:\Temp\Slitting Schedule - 2 - 202101151.csv
Sheet2

Cell Formulas
Range	Formula
A3	A3	=A1&A2&".csv"

with this

Workbooks.Open Me.Range("A3").Value