Hope some will help me with a timer
I have in column a list of Times and when the timer in colum D correspond run a url which is in column c
probably run a sound as well as a alert
Regards
Graham
Hope some will help me with a timer
I have in column a list of Times and when the timer in colum D correspond run a url which is in column c
probably run a sound as well as a alert
Regards
Graham
Last edited by Grahamfeeley; 04-22-2023 at 10:19 PM.
Hi, do you want the timer to run automatically? And if so what happens after the timer has run?
Is the time in Column A set to a next time or what?
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
thank you for your help
Yes there is a list of times and after the check time is up it looks at the next future time
I used to have vba (which I have lost) in the end column with the current time and that checked column a data
here is updated (Partial) Url file
runs automatically after I turn it on
Still you haven't answered my first question: What happens with the Rctime AFTER the timer has run?
And then, all you want it to do is open the browser to view the racetrack?
oh sorry misunderstanding
Yes I would like to run the url link to see if any change
that is why i would like to set the clock -30 Secs of real time
OR I adjust the start timesm either way is good
Thanks for your trouble
Regards
Graham
I think I have a working module but then o course I have another question🤔
You say you want to run the timer the moment you open the file, thats clear but these races only take place on certain dates or maybe on a specific date for all, so there should be an entry for a date when it is supposed to run
Let me explain: the race day is April 29 but the current date is April 24 so its not useful to open an url at 12:15 today if the race date is the 29th
Ok thank you for ther update
I usually put the new data in every day perhaps 2 hours prior to the first event
has all the times tracks and Urls
I would like to start with a start button or I run the macro that starts the countdown
EG: Tomorrow races i will attach a small sample
Thanks
Graham
Okay, I still suggest a date value in one cell to tell the code it has to look at that dat and the times in column A.
One thing however.
This last table has a different column layout than previous one.
If you do not mainatain one speciic layout it won't work
ok that is true I added a race number......so lets stick with first layout
Race time
Track
URL Link
regards
Graham
Okay, another question. I am assuming you create separate Excel workbooks for each race date.
The sample files was 2404 the last one 2504 so the date is refleced in the filename, that would be something to hold on to but then I would suggest the yymmdd format so that you can keep then in a folder knowing which file was for which year, which month which date
e.g.: 230425 ......xlsx for April 25 2023
and the columns:
Rctime Track Rcno URLS as you had in the 2504Links_Saple.xlsx
This is what I have for now.
If you open this file tomorrow it will schedule the macro to run at 11:07, the forst rance and after that trigger is executed it will set the timer to the next time - one second
When you close the workbook the timer is stopped using the workbook before close event
Tell me if it works
I really appreciate the help you have extended to me....I looked at the code and could'nt beleive it....
However i am getting one error and I will send screenshot...
regards.
Graham
The error is probably due to the fact that your Excel version may not support the Speech function.
You will have to check that out or use comment the lines with Application.Speech, place an apostrophe or delete those lines of coed the information of the next trigger is in the status bar
This the function I was using that speaks out a text
https://learn.microsoft.com/en-us/of...ication.Speech
Check if it is supported with your version of Excel of if it needs something extra
I found quite some bugs in my code
Am busy putting together anon-file dependent xlam file so that you do not have to copy the vba code to each and every new file you create.
Hi Graham,
Took some time to finetune
Give this one a try there's a PDF file attached with a short explanation and screenshots
The excel file is zipped because it exceeds the file size allowed
Did you figure out how to fic the Application.Speech ? It's still in the file but will now give an error it it still doesn't work.
The Statusbar (left bottom) will show the notificaton too.
When you close the file the last schedule will be still there and if it's still later than the moment you reopen the workbook it will de triggered again and wait until the scheduled time is tehre,
You can also schedule for the next day if you set the date to tomorrow and load the data for tomorrow
Your probably quite busy but I'm curious to know it you could use the file.
I've attached an update just in case
Well First of all Yes Iwas busy , but I have to tell you this
I AM BLOWN AWAY with what you have done here......You have gone all out and I am simply amazyed
I thank you with all my heart
HOWever I am having problems loading a race data file, I have tried all formats and still workin on it as of today 3004
Regards
Graham
PS: i will get back to you just giving you an update
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks