You can view the page at http://www.excelguru.ca/forums/conte...To-A-Directory
Ken Puls, FCPA, FCMA, MS MVP (Excel)
Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Do you have any way of doing this in VB? I know they are very similar but I'm getting a specific error when i try to convert so I'm fairly certain I'm doing something wrong.