Thread: Reference a file by concatenating cell variables
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default Reference a file by concatenating cell variables
Spelling - Change Contatenate to Concatenate.

"TomPl" wrote:

This might be what you are looking for:

=CONTATENATE("='C:\ConsolPeriod Report",TEXT(A3,"mm/dd/yy"),".xls' " & SData)

Reply With QuoteReply With Quote