Change title in an open dialog box and keep selected filename as string

[AnnieMcken]

I am using

Please Login or Register  to view this content.

but I would like to change the title of the dialog window. I tried refering to getopenfilename method (Title argument), but couldn't have something that compiles!



Also, when the user selects the file to open, is there a way to store the name of the file as a string for futur use? (Lets use

Please Login or Register  to view this content.

)

Thanks,

Annie

[Andy Pope]

that dialog has these arguments

xlDialogOpen file_text, update_links, read_only, format, prot_pwd, write_res_pwd, ignore_rorec, file_origin, custom_delimit, add_logical, editable, file_access, notify_logical, converter

if you want to change the title you will need to use the getopenfilename

Please Login or Register  to view this content.

[AnnieMcken]

This works fine to change the title, but I still have the rest of the problem:

Since the macro has to navigate between worksheets to transfer data, I cannot seem to be able to use this function as it doesn't compile:

Please Login or Register  to view this content.

I guess it is so because vntFilename is a Variant and not a string. Any options?

[Andy Pope]

unlike the open dialog, getopenfilename only returns a file(s) path and filename. You then have to open the workbook.

Please Login or Register  to view this content.