Macro wioill not select folder and File

[Howardc1001]

When I use a macro in a certain workbook to select a file in a particular folder to open and to copy the data and save the file one macro has run and then activate a macro in another workbook to open up a file in a another folder, it defaults to the previous folder and shows the previous file in the dialog box


It would be appreciated if someone could amend my code to select Folder C:\extract and file starting with EWhs

Please Login or Register  to view this content.

[cytop]

Set the InitialFileName property. This must have a trailing '\' to indicate it is a directory rather than a file.

Please Login or Register  to view this content.

Edit: That'll just set the initial directory, you can also add a file mask to further limit the files displayed:

Please Login or Register  to view this content.

[Howardc1001]

Thanks for the help and advise Cytop. This is much appreciated