Hi all, I have some files sorted depending on department in one of my E:/ location. Instead of going manually inside each folder I thought of automatic it using excel.
I assume 4 check boxes. If I select 1st check box , HR folder should open automatically which is inside E:>/ My files/All/HR If i select 2nd Check box, Engineering folder should open , which is in E:>/ My files / All /Engineering and vice versa for 6 check boxes and 6 different folders. I thought of using an user form and macro it using VBA.and create executable of it. Is it possible or any other ways are there to do it. Please give me some inputs on this. Rashmi -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
