Use current directory variable in a macro

**philmetz** · 08-16-2009, 01:37 AM

I have this in a few macros:
C:\Users\Taurus\Desktop\file.pdf

Is there anyway I can replace:
C:\Users\Taurus\Desktop

With the current directory.

As right now I have a problem if I use the excel file on other computers it cant find the directory.

Cheers

**D_Rennie** · 08-16-2009, 02:10 AM

ThisWorkbook.Path
will point to the path that the workbook containing the code is stored.

& Application.PathSeparator
can be used to navagate through folders withen the workbook path.

Hope that makes sence,
And help you in some way.

**philmetz** · 08-16-2009, 02:22 AM

so I got this code for instance:

Please Login or Register  to view this content.

But replacing the directory with "ThisWorkbook.Path" gives an error.

**DonkeyOte** · 08-16-2009, 02:53 AM

Not quite, see below:

Please Login or Register  to view this content.

**philmetz** · 08-16-2009, 03:06 AM

Thanks reps.
One other thing, would I be able to replace
\try - Copy
with whatever is say in cell A2?

**DonkeyOte** · 08-16-2009, 03:14 AM

presumably A2 will not contain the \ , ie will contain: try - copy.pdf, in which case I would suggest:

Please Login or Register  to view this content.

**philmetz** · 08-16-2009, 03:29 AM

hmmm tried it, didnt work:

Please Login or Register  to view this content.

Iv changed to cell G9 and added .pdf as the cell wouldnt contain it, should work but doesnt.
I get the error:
Document not saved...

**philmetz** · 08-16-2009, 03:40 AM

ah ok found the problem, that cell had a "\" in it

**DonkeyOte** · 08-16-2009, 03:42 AM

Did it work before you tried to use value in G9 as the file name ?

If not, this is quite a "generic" error in so far as it could be caused by a number of issues:

a) network problems (if not running against local drive obviously)

b) folder permissions

c) I've heard some people say that broken links in the file can cause issues (ie duff hyperlinks etc...)

If it worked without issue before you used the G9 value then we'd need to know the content of G9 ... might be unacceptable file name.

EDIT: all resolved... above moot.