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!

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

Recent content by ajbeer

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

Part and Inventory Search

Back
Top