I have an Excel spreadsheet that is reading in data using DDE.
Every 5 minutes this data is calculated etc.
Therefore I have the Windows API setTimer function to run a function every 5 minutes.
The problem occurs when Windows changes the system time in March and October. For some reason the 5...
Yes, the code works fine.
The program is running fine at the moment.
I am just worried that I have had a few Excel exception errors, and just wondered whether it might be the fact that I am using a Windows API function that could have caused them.
I had no problems when using an VBA timer.
In my VBA code in Excel, I am using the following function to call the Windows API setTimer
Sub StartTimer()
TimerSeconds = 300 ' how often to "pop" the timer.
TimerID = SetTimer(0&, 0&, TimerSeconds * 1000&, AddressOf TimerProc)
End Sub
I have only recently added this to my...
I have a problem, and I really don't know what the reason might be. I would very much appreciate any help anybody could give me.
I am using Excel 2000 in Windows 98.
When I open certain spreadsheets that I have been working on, they open and close extremely slowly.
This only started...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.