Directory probelm

taha54

Board Regular
Joined
Aug 11, 2006
Messages
103
hi all,
i built a program in VBA, it opens anyfile in direcotry "C:\programs\mytest" and the program also run some C++ programs using CMD , my problem is if i change the direcotry name or try to perform the program out of the directory...it fails,
how can i detect the direcotry automatically and assign it to lets say variable my_directory = direcotry of the opend file
and make my program run their without any problems

thanks
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Watch MrExcel Video

Forum statistics

Threads
1,108,502
Messages
5,523,295
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top