Excel VBA get name of highlighted folder - edit name

I would like to run this in Excel 2007 --

I have a recurring problem where co-workers have named folders under R:/All Companies/ABC Company (examples) -- and then subfolders: ABC Company 1Q2009, ABC Company 2Q2009, ABC 3Q2012.
Am using Windows XP (company edict). Naturally, these folders sort by the Quarter, then by the year. They should sort by the year, then by the quarter so I want to:

Loop through the highlighted subfolder ABC Company, put each sub-subfolder name into a variable in VBA code and then have a User Input box popup that says "The current sub-subfolder is [variable ex: ABC Company 2Q2009]. Please key in the full NEW name of the folder." The user then keys in "ABC Company 2009Q1". Hits OK and the VBA loops to the next sub-sub folder, etc.

Since the folder names are not consistent -- for example...everyone using the above (incorrect) file naming structure, someone else might use "XYZ Co - 3Q01", it is not possible to edit or change the current folder name....the user (me) needs to be able to key in an entirely new, correct name.

I want to start on the sub-sub folder..... in other words, highlight R:/All Companies/<the name of the Company>.

I am fairly decent at Access VBA but I just haven't used Outlook VBA enough to know my way around.

Thanks for your help.

Good question. I use 2 monitors. So, I would have Explorer open on the left and highlight the folders there and run the Excel VBA on the right. If I can do it that way.