ExcelBanter - ThisWorkbook.Path in formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - ThisWorkbook.Path in formula (https://www.excelbanter.com/excel-programming/430095-re-thisworkbook-path-formula.html)

Bernie Deitrick

ThisWorkbook.Path in formula

ActiveCell.FormulaR1C1 = _
"=VLOOKUP(R[-1]C[-1],'" & ThisWorkbook.Path & _
"\[World-TimeCheck.xls]DB'!C1:C5,5,FALSE)"

HTH,
Bernie
MS Excel MVP

"Kashyap" wrote in message
...
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)"

All times are GMT +1. The time now is 11:54 AM.