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

"Jeff" wrote in message
...
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

If I understand you correctly, the user installs the xls files where he
wants. Then the user opens one.

You can then retrieve the directory of the open file using
Thisworkbook.Path

Is that what you wanted?

Geoff

Thisworkbook.path would refer to the workbook running the code. It seems
like Activeworkbook.Path might be more appropriate for the situation
described - unless the code being developed is going to be placed in each
workbook.

--
Regards,
Tom Ogilvy

"GB" wrote in message
...

"Jeff" wrote in message
...
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

If I understand you correctly, the user installs the xls files where he
wants. Then the user opens one.

You can then retrieve the directory of the open file using
Thisworkbook.Path

Is that what you wanted?

Geoff