Hi i don't know about the increase in file size but i notice you haven't stopped the screen updating in your subs. i know there're not vary long pieces of code but that might help speed them up.
application.ScreenUpdating = False
'' your code here
Application.screenUpdating = True