Macro for auto printing. macro printing at same time 17:30 but do not repeat.

Hi

I have a Macro that print a document every day at 17:10. This is working fine but my problem is that I need to close and re open the spreadsheet to ensure it print the following day again.
So what I want to accomplish is to leave the spreadsheet open all the time and just execute a print every night at 17:10. I am currently using Application.Ontime TimeValue (``17:10:00``)
I there a way to overcome this?

Thanks

Welcome to the Forum!

There is no way to know without seeing your file. Can you attach it?

To post a file, under the text box where you type your reply click the Go Advanced button. Then in the next screen look above the reply box and click the paper click icon. You will get a pop-up screen. Click Add then Select to select a file from your local drive, upload it, and then click Done to attach it. It will be displayed underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.

Originally Posted by aburger

Hi

I have a Macro that print a document every day at 17:10. This is working fine but my problem is that I need to close and re open the spreadsheet to ensure it print the following day again.
So what I want to accomplish is to leave the spreadsheet open all the time and just execute a print every night at 17:10. I am currently using Application.Ontime TimeValue (``17:10:00``)
I there a way to overcome this?

Thanks

Please Login or Register  to view this content.

Hope This help.

Thanks




Moderator's Note: Welcome to the forum. When posting codes be sure to enclosed it with code tags. Select the codes then hit the "#" symbol, I'll do it for you now. Thank you.