Open and closing a workbook using On.Time Application

I have a read only workbook that is used on roughly 25 workstations daily. This workbook contains details for all of our customer specs. I update this often sometimes daily as the specs change or new customers are added. This excel file is located on our network drive and each work station has a short cut that points to the network drive to launch the read only file. Once the excel file is opened at the work station the user has to enable the macros for the workbook to function properly. In the workbook I have a routine in place that runs at 5pm to close the workbook and then reopen it. It works as it should on the day the file is opened but come the next day at 5pm it doesn't run the routine again. I think it has something do with killing the timer but I am not sure. Any and all help would be appreciated. I have copied the code below, most of this I found on the web!

What I am trying to acheive is to have the most current information at all of our workstations without having to personaly go around to close and reopen the excel file or to count on everybody doing it everyday.


Thisworkbook

Please Login or Register  to view this content.

Module

Please Login or Register  to view this content.

Hi AmosInOhio and welcome to ExcelForum.

The following thread may answer your question. You may have to add a date reference: http://stackoverflow.com/questions/2...-time-tomorrow

The TimeValue() function returns a decimal number between 0 and 1 indicating the fraction of a day. Try adding 1 to have the time use tomorrow (i.e. add 24 hours).

--------------------------
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Lewis