VBABEGINER
Well-known Member
- Joined
- Jun 15, 2011
- Messages
- 1,284
- Office Version
- 365
- Platform
- Windows
Hi All,
Unable to gauge why error come..
Error on red line
B7 =
E9 = 2018, B3 = Folder Name (i.e. 6.Jun'18)
shtSu = Sur.xlsx
Unable to gauge why error come..
Error on red line
Code:
pth = Workbooks("QDC.xlsb").Sheets("Home").Range("B7").Value
[COLOR=#ff0000]
Workbooks.Open Filename:=pth & shtSu, UpdateLinks:=False[/COLOR]
B7 =
Code:
="\\group$\Common\Dashboard\QDC data\"&E9&"\"&B3&"\"
E9 = 2018, B3 = Folder Name (i.e. 6.Jun'18)
shtSu = Sur.xlsx