Hi all, I want to allow the user of my macro to see and navigate through the directory structure and to select a target directory that the macro can. I was hoping there was something "like" GetOpenFileName that would return the directory string. I'm sure it's possible to code such a function from scratch, but I'm not sure I'm up to that. Was never slick at this and now I'm rusty on top of that. Looking for the easy way out.
In Excel 2002 under XP. Thanks, Tony. --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---