Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Local file read
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Local file read
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 -- Regards, Tom Ogilvy "Al" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Local file hyperlinks opening in IE | Excel Discussion (Misc queries) | |||
Can not copy the file from server to my local C:\ | Excel Discussion (Misc queries) | |||
Hypoerlink to a Local file and emailing the file as an attachment | Excel Discussion (Misc queries) | |||
Reference styles and local/non-local formulae - international problems. | Excel Programming |