Thread: ThisWorkbook.Path in formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kashyap Kashyap is offline
external usenet poster
  
Posts: 131
Default ThisWorkbook.Path in formula
Hi, I have below code.. I want to change something like ThisWorkbook.Path & "\

Can anyone help me on this?

ActiveCell.FormulaR1C1 = _
"=VLOOKUP(R[-1]C[-1],'E:\\Repository-HC\Primary\Unnati\June
09\Res\Misc\[World-TimeCheck.xls]DB'!C1:C5,5,FALSE)"
Reply With QuoteReply With Quote