View Single Post
 
Old 08-28-2014, 01:15 PM
ryanjohnsond@gmail.com ryanjohnsond@gmail.com is offline Windows 8 Office 2007
Novice
 
Join Date: Aug 2014
Posts: 18
ryanjohnsond@gmail.com is on a distinguished road
Default

Quote:
Originally Posted by excelledsoftware View Post
While it is on my mind I just though of 2 things you should do when you run this script the first time.
number1 open a new blank workbook and put this code into a module.
number2 try it on a folder with a few BACKED UP excel books in it.
Check the results and if everything looks good back up the intended folder and run it.
I think I did it correctly. I saved it as a Macro.xlsm, and ran it. For some reason the second folder, Column D didn't get properly changed. Weird.

Last edited by ryanjohnsond@gmail.com; 08-28-2014 at 03:32 PM.
Reply With Quote