Directory starting witht the Current Directory

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select the Name of the Worksheet with InputBox 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Directory Structure starting with the Current Directory .. 0
Word macro that can call cells out of Excel for a find and replace 0
Select worksheet with Application Input box??? 1
VBA project - OpenExcelFile 2
Code does as instructed, but creates and saves a Book1 2
Force to Directory 3

Top