Showing posts with label Select folder. Show all posts
Showing posts with label Select folder. Show all posts

Thursday, June 30, 2016

How select folder using excel VBA code?

Many a times we need to select folder to get input data path during project automation. Which we will be the first activity before macro execution. Selecting folder using dialogue box is very vital task any any automation activity. it helps as a input data validation to use correct input data in further execution. Also, it help to achieve data quality in report automation task.




Folder selection can be implemented by writing a short VBA code,