I was looking for some help on creating refresh code on external web data exactly on the minute Ex. 8:00:00 am, 8:01:00am, etc....
I know how to import the data, but can't get the refresh time to systematically refresh on the :00 sec.
Thanks.
I was looking for some help on creating refresh code on external web data exactly on the minute Ex. 8:00:00 am, 8:01:00am, etc....
I know how to import the data, but can't get the refresh time to systematically refresh on the :00 sec.
Thanks.
Try this:
![]()
Please Login or Register to view this content.
Hello Inwalkedbud,
You can set the refresh rate to 1 minute, but as to controlling it down to the second may not be possible. I am not a DDE expert, but I would have to say probably no you can't. DDE is asynchronous. The Excel client sends a Windows message to the server and carries on processing. Windows holds the message and sends it to the server when the server is ready to process it.
Sincerely,
Leith Ross
Last edited by Leith Ross; 10-01-2007 at 03:03 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks