Macro help.

[mdalasta]

Hello, I am new to this forum. I have a macro question.

We have an excel "master" file on the network and we input our daily sales into this. I would like to make our retail people's jobs easier. I would like them to open the master file, and after they enter the information in..click on the macro and here's what I need the macro to do...Save the worksheet (with a new file-name, from a cell that has the =()today's date function), print said file and close excel altogether. I have a good start, but it's not working properly. Any help would be greatly appreciated. Here is the macro as I have it...


Capture.jpg

Please Login or Register  to view this content.

[arlu1201]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.