hi.
does this work for you?
![]()
eSAUK = "'\\corpusfs12\PROJECT-REPORTS\Pathfinder Reporting\Heather Lations\EMEA WEEKLY PHONE REPORT\2014\[EMEA SA UK.xlsx]" ActiveCell.Formula = "=VLOOKUP(B3," & eSAUK & "Table1'!$A:$B,2,0)"
hi.
does this work for you?
![]()
eSAUK = "'\\corpusfs12\PROJECT-REPORTS\Pathfinder Reporting\Heather Lations\EMEA WEEKLY PHONE REPORT\2014\[EMEA SA UK.xlsx]" ActiveCell.Formula = "=VLOOKUP(B3," & eSAUK & "Table1'!$A:$B,2,0)"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks