GetOpenFilename Question

[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

 

[Chip Pearson]

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

 

[Tom Ogilvy]

Unfortunately, you can't make up arguments for a function.

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

See help for details.