GetOpenFileName

[GetOpenFileName]

I am trying to learn how this instruction works. Could
you show me how the code looks to execute this command on
these 3 files...

c:\1.xls,c:\2.xls,c:\3.xls ?

Thank you very much for your guidance.

 

[Vasant Nanavati]

Hi:

GetOpenFileName is a macro method that allows the user to select a file, and
returns the full path and name of the file selected.

For example:

Workbooks.Open Application.GetOpenFileName

will provide a FileOpen dialog and then open the workbook that the user
selects.

MsgBox Application.GetOpenFileName

will also provide the same FileOpen dialog, but will simply display in a
MessageBox the path and name of the file selected by the user.

Regards,

Vasant.