Help with location?

[Robert Couchman]

hello all,

i have previously used a bit of code that would open a
file from the same location as the current open document..

activedocument.activefolder.. or something like this!!

can anyone please tell me the correct code to use?

i can add the file name onto the end!

thank you,

Robert Couchman
([email protected])

 

[Tom Ogilvy]

ActiveWorkbook.Path & "\filename.xls"

or

Thisworkbook.Path

 

[Bob Phillips]

?ACTIVEWORKBOOK.Path

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)