How to make Excel refresh a file ?

Status
Not open for further replies.
S

swar

Newbie level 5
Joined
Mar 9, 2006
Messages
9
Helped
3
Reputation
6
Reaction score
2
Trophy points
1,283
Activity points
1,346
I am currently doing a labview program the results will be saved in to an Excel file.
I would like to see the updates in excel as the time goes. I mean that excel should refresh. Can anybody help me in telling me how to do this?
 

Re: Excel help

You would be better writing a VB program with an activeX grid control that refreshes from the file.
 

    S

    swar

    Points: 2
    Helpful Answer Positive Rating
Re: Excel help

You could write a macro in VBA excel to make it refresh... just push a button or a key stroke to trigger the macro...
 

    S

    swar

    Points: 2
    Helpful Answer Positive Rating
Re: Excel help

DarkJedi said:
You could write a macro in VBA excel to make it refresh... just push a button or a key stroke to trigger the macro...
Click to expand...
or ask VBA excel to refresh each second (for example)
another idea, test file size and reload it if it has changed
Code: 
Sub MeasureSize()
Dim TheFile As String
TheFile = "c:\scan1.xls"
With CreateObject("Scripting.FileSystemObject")
MsgBox .GetFile(TheFile).Size & " bytes"
End With
End Sub
 

Re: Excel help

tgq great ideas... VBA with Excel is a very powerfull tool, i have written some macros myself to help me out on work. I even had one to launch some batch programs and connect to server to get information out of them and process it afterwars.

I think tgq ideas are the way to go.
 

Status
Not open for further replies.

Similar threads

Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…