Thread: How to Reference an excel file with a changing name
View Single Post
 
Old 09-02-2022, 07:33 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
If, again, you have a proper Excel date in cell E1, you can refer to cell C3 on sheet Sheet1 of the open file with:
Code:
=INDIRECT("'[OpsMeeting_" & TEXT(E1,"m-d-yy") & ".xlsx]Sheet1'!C3")
Reply With Quote