Hello,

I work in admin, but have been given an urgent excel visual basic project to
complete

I have to redevelop a section to work from the current system directory, and
not the physical directory, the *.xls file was originally saved to

The runtime error I get is with this line of code.........ChDir
"C:\apps\data", but the files are all stored in c:\projects, but if a user
takes the files and installs them on a different directory on his or her
machine, there is no way i can know what directory on c:\ they will install
to, so i cant hardwire the code, so have to have some means, in vbasic of
having things to work from the current directory of whichever pc the files
are stored on

Please help

Thanks in advance
Jeff