Serach file according to path

[Sigal Laniado]

My exe file is reside in a directory such
as "v:\mp\ae\exe\ae.exe" and I have a log file in
"v:\mp\ae\resources\log\ae.log"

In the customer site there is no "V:\" directory
how can I tell my application to find the log file
in "\\\resources\log\ae.log"
Please help
Thanks sigal

[Lothar Haensler]

not sure, if I understand your problem, but,
if your exe resides in "\mp\ae\exe\"
and you want to access a file in "\mp\ae\resource\log"
try this:

dim strDir as string
strDir = app.path
chdir app.path
' change to logfile dir
chdir "..\..\resources\log"
strLogDir = curdir
open curdir & "\ae.log" for output as #hFile

[Dr_Michael]

Try to use the FileSystemObject:
Set a reference to your project:
Microsoft Scripting Runtime

add this code:


dim fso as FileSystemObject
set fso = new FileSystemObject




Then, write "fso." At the time you press the ".",
a list with all properties, methods will appear, I believe you will find there what you need. I cannot remember exactly the property name that you need. Good luck!

Michael Vlastos
Automation Engineer
Company SouthGate Hellas SA
Development Department
Athens, Greece