Invoke Windows shell: Read selected file name for variable

[andydtaylor]

Hi,

I can't figure out how to do this! Can anybody help me?

I'd like (the user) to open a selected folder, and select a csv file. Then use that file name later - either reading it straight into vba or taking it into vba from a cell value.

Sorry if this is covered somewhere else on the forum - I just can't find it.

Regards,

Andy

 

[andydtaylor]

Any ideas? Thanks