Yes the second macro is the import data macro, the first being th
button macro. I just realized that I will have to mess with it ever
month anyways due to task manager only opening up the one mont
workbook unless I tell it to open all of the workbooks

--
buzzharle
-----------------------------------------------------------------------
buzzharley's Profile: http://www.excelforum.com/member.php...fo&userid=3588
View this thread: http://www.excelforum.com/showthread.php?threadid=55947