ExcelBanter - Choosing a directory/file

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Choosing a directory/file (https://www.excelbanter.com/excel-programming/308268-choosing-directory-file.html)

Srikanth[_6_]

Choosing a directory/file

I want the macro to ask the user which folder/file to use to get data.
The user should be able to browse to the correct folder/file. How to
do this.

Srikanth

Vasant Nanavati

Choosing a directory/file

See John Walkenbach's site:

http://j-walk.com/ss/excel/tips/tip29.htm

--

Vasant

"Srikanth" wrote in message
m...
I want the macro to ask the user which folder/file to use to get data.
The user should be able to browse to the correct folder/file. How to
do this.

Srikanth

All times are GMT +1. The time now is 11:36 PM.