How do I add a blank row before data groups during import of CSV

Hi Guys and Gals,

This is my issue, I have been given a spreadsheet containing absolute folderpaths right down to the filename
e.g.
\\server\data\workgroup\admin\planner.xlsx
\\server\data\workgroup\admin\roster.xlsx
\\server\data\workgroup\admin\ops\call log.doc
etc etc

Now i have been tasked with importing this information into a new spreadsheet that looks like this
\\server\data\workgroup\admin
planner.xlsx
roster.xlsx
\\server\data\workgroup\admin\ops\
call log.doc

I am hoping there is a way to automate this using VBA but sadly cant seem to figure out a way.

Any and all help will be greatly appreciated.
Aussiexile

Hi Venkatpvc,

Thanks for the reply bit its not quite what i was looking for.

What i need to be able to do is insert a row above the folder groups and populate it with the folderpath then remove the folderpath from the file names like your code above.

Im not really familiar with regexp to know if it is capable of handling this.