Use ThisWorkbook.Path to get the full path name of the workbook.
Use CurDir to get the current default path. You can run an exe
file by using the Shell command. See help for more details.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Domagoj Vulin" wrote in message
...
I have 2 questions:
1. how can I determine the current working folder of a XLS file
with a
macro? GetAbsolutePath didn't give me the best results...
2. is it possible to run .exe program from a VBA macro and how?