How to input file name in user form
I have a VBA script that searches for all the Excel files in a
directory tree and makes batch updates. I currently input the root directory path in a simple text control, but would like to be able to allow the user to browse for the path. Is there an fairly quick and easy way to do that? Thanks, Boris |
How to input file name in user form
If you're using xl2002+, you can read about:
Application.FileDialog in VBA's help. If before, then Jim Rech has a BrowseForFolder routine at: http://www.oaltd.co.uk/MVP/Default.htm (look for BrowseForFolder) Or John Walkenbach's: http://j-walk.com/ss/excel/tips/tip29.htm Boris Pelakh wrote: I have a VBA script that searches for all the Excel files in a directory tree and makes batch updates. I currently input the root directory path in a simple text control, but would like to be able to allow the user to browse for the path. Is there an fairly quick and easy way to do that? Thanks, Boris -- Dave Peterson |
All times are GMT +1. The time now is 07:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com