Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / March 2008

Tip: Looking for answers? Try searching our database.

Real time clock

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jase - 20 Mar 2008 20:44 GMT
I have this code to display a real-time clock on a worksheet. However if I do
anything else with in the workbook or worksheet such as type in a cell i get
an error message "application defined or error defined error". How do I get
rid of this problem?

Function GetRealDate() As Date
   
   Dim ieApp As Object
   Dim i As Long
   Dim strTime As String
   Dim strHour As String
   Dim strMinute As String
   Dim strSecond As String
   Dim lFirstCom As Long
   
   Const sURL = "http://www.time.gov/timezone.cgi?Central/d/-6"
   Const lElement As Long = 36
   Const ieREADYSTATE_COMPLETE As Long = 4
   
   Set ieApp = CreateObject("InternetExplorer.Application")
   
   ieApp.navigate sURL
   
   Do
       DoEvents
   Loop Until ieApp.ReadyState = ieREADYSTATE_COMPLETE
   
   strTime = Left(ieApp.Document.all(lElement).innertext, 40)
   
   'store hour
   strHour = Left(strTime, 2)
   
   If Right(strHour, 1) = ":" Then
       strHour = Left(strTime, 1)
   End If
 
   'store minute
   strMinute = Mid(strTime, 4, 2)
   
   'store second
   'strSecond = Mid(strTime, 7, 2)
   
   Sheets("Actual").Range("I2").Value = strHour
   
   Sheets("Actual").Range("J2").Value = strMinute
   
   'Range("C1").Value = strSecond
       
End Function
Gary''s Student - 20 Mar 2008 23:07 GMT
1. the app must be a sub, not a function. A function can't change aribtrary
cell in the worksheet

2. make sure you have loaded any required Library References
Signature

Gary''s Student - gsnu200774

> I have this code to display a real-time clock on a worksheet. However if I do
> anything else with in the workbook or worksheet such as type in a cell i get
[quoted text clipped - 45 lines]
>        
> End Function
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.