Hi,

My "CurDir" does not work. I have:

Dim File_path As String
File_path = CurDir("")

Instead of showing my current directory (where the workbook I currently have
open lies), is it showing the directory of previously opened file, i.e. the
top file in the quick access list of files that can be found in the
menu/files.

Please help,

If you want the path in which the workbook exists, use Thisworkbook.Path.


--

Ray at work
Microsoft ASP/ASP.NET MVP


"Jim73" wrote in message
...
Hi,

My "CurDir" does not work. I have:

Dim File_path As String
File_path = CurDir("")

Instead of showing my current directory (where the workbook I currently
have
open lies), is it showing the directory of previously opened file, i.e.
the
top file in the quick access list of files that can be found in the
menu/files.

Please help,

or activeworkbook.path

Jim73 wrote:

Hi,

My "CurDir" does not work. I have:

Dim File_path As String
File_path = CurDir("")

Instead of showing my current directory (where the workbook I currently have
open lies), is it showing the directory of previously opened file, i.e. the
top file in the quick access list of files that can be found in the
menu/files.

Please help,



--

Dave Peterson

Thanx


"Dave Peterson" wrote:

or activeworkbook.path

Jim73 wrote:

Hi,

My "CurDir" does not work. I have:

Dim File_path As String
File_path = CurDir("")

Instead of showing my current directory (where the workbook I currently have
open lies), is it showing the directory of previously opened file, i.e. the
top file in the quick access list of files that can be found in the
menu/files.

Please help,



--

Dave Peterson