Continue to Site

Welcome to EDAboard.com

Welcome to our site! EDAboard.com is an international Electronics Discussion Forum focused on EDA software, circuits, schematics, books, theory, papers, asic, pld, 8051, DSP, Network, RF, Analog Design, PCB, Service Manuals... and a whole lot more! To participate you need to register. Registration is free. Click here to register now.

Register Log in

How to make Excel refresh a file ?

Status
Not open for further replies.
S

swar

Newbie level 5
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

Part and Inventory Search

Welcome to EDABoard.com

Sponsor

Back
Top