How to Reference an excel file with a changing name

		Microsoft Office Forums > Microsoft Excel > Excel
How to Reference an excel file with a changing name

09-02-2022, 07:33 AM

p45cal

Windows 10 How to Reference an excel file with a changing name

Office 2019

Expert

Join Date: Apr 2014

Posts: 962

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")

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2000 Backup File Modification Date Not Changing When I Save an XLS File	skeezix	Excel	3	01-10-2021 04:51 PM
Changing legends in graph if linked excel file is not available?	DatS	Word	3	10-18-2015 05:44 PM
Changing Field Links in a Word Document from one excel file to another	Fed77	Word VBA	9	07-08-2015 02:24 AM
Code for mail merge to reference saved excel file	jtemp57	Word VBA	10	12-16-2013 11:02 PM
Changing the Font of Cross-reference	welchs101	Word	1	06-07-2013 05:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:10 PM.