Directory starting witht the Current Directory

  • Thread starter Thread starter Neeraja
  • Start date Start date
N

Neeraja

Hi,
In my Excel Macro, the User selects the file to open.I
have used the following command.

ExcelFile1 = Application.GetOpenFilename("Excel-
files,*.xls", _
1, "Select Input File To Open", , False)
If TypeName(ExcelFile1) = "Boolean" Then Exit Sub

But the directory structure starts with "My documents".
In the Windows Explorer I want the Directory start from
the Current Directory in which my Excel Macro is saved.

Can someone suggest me how I solve this!!
Thanks in advance for any help.
Neeraja.
 
Back
Top