Can anyone solve this below problem
I have two worksheets as follow:
In sheet1 of worksheet FGSummary.xlsx, I need value of cell J1 of sheetname(NResSoak) of worksheet FGSummary_PossibleToRes_20140121.Xlsx Full Path:='\\192.168.9913\SSRS_DailySummaryReport\[FGSummary_PossibleToRes_20140121.xlsx]NResSoak'!$J$1
Please note that the red highligted is date in the worksheet name (Format: YYYYMMDD) and it changes daily.
I tried below formula but it doesn't work
C1 = today's date (Format: YYYYMMDD) which is 20140121
I appreciate if you could solve this problem