Excel Visualbasic

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

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 said:
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
Click to expand...

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.
 
Back
Top