Wilson WindowWare Tech Support

WinBatch WinBatch+Compiler WebBatch
Home | Tech Database | Tech BBS | White Papers | Purchase


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