It worked! Thank you so much! Question 2 lol. Can I make the sheet refresh upon opening? and is there anyway to make it save to pdf with out prompting for a file name? I am trying to automate a report and run it on the server. With windows task scheduler I can now automate sending it out, I just need to complete automate the report so it can run itself.