View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim73 Jim73 is offline
external usenet poster
 
Posts: 8
Default CurDir does not work

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