Thread: Linking to Workbooks that Change Name Daily
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pwk pwk is offline
external usenet poster
  
Posts: 9
Default Linking to Workbooks that Change Name 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!

Reply With QuoteReply With Quote