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



"JackJ" wrote in message
...
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