WinBatch Tech Support Home

Database Search

If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.

TechHome

How To
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus
plus

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

Query excel statusbar

Keywords:     Check excel status bar

Question:

Is there any way to look at the status bar in Excel???

Answer:

Yes, something like....
	
channel = DDEInitiate("Excel", "System")     ;Initialize DDE for showcase query link and check status.
;
Message("DDE channel name or handle", channel)
;
If channel != 0                                 ;If DDE OK
                                                ;Do DDE Request
        result = DDERequest(channel, "StatusBar")
        DDETerminate(channel)                   ;Close DDE
;        WinClose("Vista")                     ;Close Report
        If result == @FALSE
                Message("DDE Execute", "Failed")
        else
                Message("DDE Request", "Return data is... %result%")
                Exit
        endif
else
        Message("DDE operation unsuccessful", "Check your syntax")
endif
Return



Article ID:   W14609
Filename:   Query Excel status bar txt.txt
File Created: 2000:06:15:14:06:48
Last Updated: 2000:06:15:14:06:48