DDE Topics for Excel 97

I am trying to drive an Excel spreadsheet from an external application (Mercury Interactive's WinRunner). I have a dll which implements the dde_execute function, which allows me to perform operations like
Execute("Excel", "system", "[OPEN("default.xls")]");
Execute("Excel", "system", "[SAVE]");
Execute("Excel", "system", "[QUIT]");
etc.

I am trying to find out the valid system and sheet topics (i.e. the [QUIT], [SAVE] bits). I have been mostly guessing until now. Can anyone point me in the right direction where I can get hold of this info? Preferrably free on the net somewhere!

Thanks
crobbAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
david_levineConnect With a Mentor Commented:
How abour right from the horses mouth!

Go to: http://support.microsoft.com/support/downloads/LNP129.asp and download and run macrofun.exe which installs macrofun.hlp. This help file contains, among other things a list of DDE commands for Excel. Help File Topic: DDE & External Macro Functions

David

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.