Posted to microsoft.public.excel.programming

external usenet poster

Posts: 131

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ThisWorkbook.Path in formula	Bernie Deitrick	Excel Programming	0	June 19th 09 05:58 PM
Remove end folder from path found with ThisWorkbook.Path command ?	dim	Excel Programming	9	April 23rd 08 06:04 AM
ThisWorkbook.Path not working...	rmullen	Excel Programming	3	January 17th 06 08:14 PM
ThisWorkbook.Path not updating	Bruce	Excel Programming	1	January 28th 05 04:39 AM
ThisWorkbook.Path	Birdy	Excel Programming	1	February 10th 04 02:50 AM

All times are GMT +1. The time now is 10:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us