Local file read

[Al]

Hello all,

I am trying to get a macro to open another excel file local to the
worksheet that the macro is in. So far, only absolute paths have
worked.

I have tried "." and "./" in front of the file name, but to no avail.
Is it possible to do this without an absolute path?

Thanks!
-=Al

 

[Tom Ogilvy]

I guess it depends on how you are trying to use it, but:

? dir(activeworkbook.FullName)
file2.xls
? dir(activeworkbook.Path & "\")
file2.xls
? dir(activeworkbook.Path & "\.")
file2.xls

if I then drag in a .txt file to the same directory as the workbook

? dir(activeworkbook.Path & "\*.txt")
August31.txt