PDA

View Full Version : Help on merging wbksheets



jeffcrtra
04-02-2011, 01:18 PM
Hey Guys,
I must say this ste has helped me so much that I'm truly grateful to you guys.
Awesome site.

My question is this, I'm using the code called "Combine All Workbooks from One Folder Skipping Blank Sheets (http://vbaexpress.com/kb/getarticle.php?kb_id=829)" from this website.
Works perfectly, the only thing I need to change is that instead of using a "customized" broswer how can I use change it to the windows explorer?
That's because the browser within doesnot recognize shortcuts and some paths are long due that I get info from servers away.

I would really appreciate the help.

Have a great day.