Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ajbeer

    Problem with VBA code when Windows changes to dalylight saving time.

    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...
  2. ajbeer

    setTimer - causing exception errors?

    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.
  3. ajbeer

    setTimer - causing exception errors?

    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...
  4. ajbeer

    Excel spreadsheets opening and closing VERY slowly

    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...

Part and Inventory Search

Back
Top