Hi,
The code as is should work. However, if the format of the actual file is different it will not work.
Also, If you are wanting to run the code on files you receive each month you will need to have the code in a separate workbook and have it "Open" the new data file and the run the rest of the code. Check your "PM"
Off for the nite will be back tomorrow
Last edited by charlesdh; 07-09-2014 at 04:35 PM.
Reason: Added msg
|