CurDir Doesn't Work Properly

[Thales42]

Excel 2007 CurDir acts a bit strangely. If I create a new Excel file in c:\Excel and in that file query the value of CurDir it will indeed return c:\Excel as expected.

Please Login or Register  to view this content.

But if I then copy that Excel file over to D:\Junk then CurDir will still return c:\Excel where the file was created, NOT the directory where the file currently resides.


Is there some way to always find the CurDir value of where the file currently resides and is executing from?

Thanks.

-----------------------------------------------------------------

A kludge solution seems to be to use ActiveWorkbook.FullName as follows:

Please Login or Register  to view this content.

[Joske920]

hi,

maybe : Application.ActiveWorkbook.Path
havent checked in event of save as

Grtz

[Thales42]

Re: maybe : Application.ActiveWorkbook.Path

Thanks Grtz - that looks like a cleaner solution than mine. Seems to work in a quick test of moving files around.

Bill

[Joske920]

Hi,

If this is solved please mark it as such thx.

Grtz

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Thales42]

Hi,

If this is solved please mark it as such thx.

Grtz

I would so mark it if I knew how. Nowhere on the page does the word "Solved" occur according to a Ctrl-F page search. And nothing equivalent jumps out at me. I've added a tag if that is what's required. Thanks.
----------------------

I've manually added [Solved] to the title if that's the right approach.

[FDibbins]

hi,

maybe : Application.ActiveWorkbook.Path
havent checked in event of save as

Grtz

I have removed your advertisement from your signature - please read the rules regarding that.

[mc84excel]

But if I then copy that Excel file over to D:\Junk then CurDir will still return c:\Excel where the file was created, NOT the directory where the file currently resides.

This is a quirk of CurDir caused by changing to a different drive. To work around this, you need to change the drive and then change the directory.

I have included an extract of some code below that you may find helpful.

Please Login or Register  to view this content.