PC Review


Reply
Thread Tools Rate Thread

Dynamic charting; Diff between exec 2000 and 2007

 
 
Mike K
Guest
Posts: n/a
 
      7th May 2009
Oh Wise Ones,

I may have posed this question before, but has anyone else noticed a
difference in the way Excel 2000/Win2000 and Excel 2007/XpPro handle dynamic
charting?
I use application.calculatefull to update my sheet. The numbers in the
columns change, but the chart will not update- it maintains the last number
until i call "refresh sheet" from the dropdown menu that accompanies the
addin that handles the SQL calls. That is with excel 2007. A different
machine running the EXACT same worksheet running excel 2000 updates the chart
continuously while the macro is running. Why the difference? And how can I
replicate "refresh sheet" from the password protected addin?

Thanks,
Mike

My macro in a general module

Dim KeepRefreshing As Boolean
Sub StopRefresh()
Range("A2").Select
With Selection.Interior
.ColorIndex = 3
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
Range("E2").Select
KeepRefreshing = False
End Sub
Sub AutomaticRefresh()
If KeepRefreshing Then
Application.OnTime Now + TimeValue("00:00:02"), "RefreshThisSheet"
'Application.Caption = Sheets("Lab").Range("A50").Value
End If
End Sub
Sub StartAutoRefresh()
' This function sets it all going, by setting the flag and
' making the initial call to RefreshThisSheet
Range("A2").Select
With Selection.Interior
.ColorIndex = 50
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
Range("E2").Select
KeepRefreshing = True
RefreshThisSheet
End Sub
Sub RefreshThisSheet()
' This function refreshes the sheet, and then calls the
AutomaticRefresh
' function, which will call it back in a couple of seconds
Application.ScreenUpdating = True
Application.CalculateFull
AutomaticRefresh
End Sub








 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
dynamic charting brian.baker13@googlemail.com Microsoft Excel Discussion 0 10th Nov 2007 03:36 PM
dynamic charting brian.baker13@googlemail.com Microsoft Excel Discussion 1 10th Nov 2007 03:31 PM
Excel 2007 and dynamic charting =?Utf-8?B?c21hcnV6emk=?= Microsoft Excel Charting 5 17th Jun 2007 07:19 PM
Dynamic Charting sergv Microsoft Excel Misc 2 2nd Sep 2005 04:43 PM
Dynamic insert/update (ala EXEC SQL DESCRIBE) Tim Nelson Microsoft VB .NET 1 25th Sep 2003 11:44 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:15 PM.