Run executable file

[S_Wish]

Hi! I have a problem with self-written *.exe program which is working with current directory. When i run it manually, it does fine. but if i try to do it using VBA - the pass to current directory changes (like excel copies it to some directory and run). can someone explain me how excel runs executables? because now i had to change pass to static in *.exe program, and it is not convinient for future usage.

Thanks in advance.

 

[Jaafar Tribak]

Hi! I have a problem with self-written *.exe program which is working with current directory. When i run it manually, it does fine. but if i try to do it using VBA - the pass to current directory changes (like excel copies it to some directory and run). can someone explain me how excel runs executables? because now i had to change pass to static in *.exe program, and it is not convinient for future usage.

Thanks in advance.

Look for the Shell Command

 

[S_Wish]

just to be clear, i do use shell
here is my code

Call Shell(ThisWorkbook.Path & "\MYFILE.exe", vbNormalFocus)

error in Pass:
for example my file is in directory: D:\work\
and after calling shell i get error with pass
C:\Users\me\Documents\

 

[S_Wish]

any thoughts why it moves my .exe file to directory C:\Users\me\Documents\ to run instead D:\work\ ?? and how to cure it?

 

[John_w]

Try:

Shell "D:\work\MYFILE.exe", vbNormalFocus