ExcelBanter - Linking to Workbooks that Change Daily

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Linking to Workbooks that Change Daily (https://www.excelbanter.com/excel-discussion-misc-queries/125169-linking-workbooks-change-daily.html)

pwk

Linking to Workbooks that Change Daily

I am trying to link to another workbook to extract data daily. The
problem is the page name changes on a daily basis. Can I use wildcards
to do this? Maybe there's another way. Here are the references:

'[DOC - Daily Composite.xls]142007, 1'!$F$381

'[DOC - Daily Composite.xls]742996, 1'!$F$381

Thanks!

All times are GMT +1. The time now is 11:01 PM.