Linking to Workbooks that Change Daily

P

pwk

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking to Workbooks that Change Name Daily 3
Sub projects added as read only in Master file which are saved on sharepoint 1
Linking data in MS Word into Excel 5
Changing Monthly Data to Daily Data? 1
Many sheets, one DB? 1
Compiling Revenue Reports 1
Automation of copy/pasting data and retrieving results 0
Input Box 2

Top