GetOpenFilename Question

  • Thread starter Thread starter JackJ
  • Start date Start date
J

JackJ

When using this dialog box, it is useful sometimes to help users make their
selection, like you can with GetSaveAsFilename, thus:

st = Application.GetSaveAsFilename(Cells(3, 9), "*.mat, *.mat")

But when I try inserting a cell reference into GetOpenFilename it fails,
thus:

st = Application.GetOpenFilename(Cells(3, 9), "*.mat, *.mat")

This fails.

None of my books seems to address this. Has anybody a solution?

Thanks
 
Jack,

The syntax of GetOpenFilename is different than that of
GetSaveAsFilename, namely that GetOpenFilename doesn't have an
InitialFileName arguement. See help for the exact syntax of both
methods.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Unfortunately, you can't make up arguments for a function.

the getopenfilename does not have an InitialFileName property (like
GetSaveAsfilename)

See help for details.
 
Back
Top