?
Solved

DDE Topics for Excel 97

Posted on 1998-12-26
1
Medium Priority
?
265 Views
Last Modified: 2006-11-17
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
0
Comment
Question by:crobb
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 9

Accepted Solution

by:
david_levine earned 400 total points
ID: 1615310
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

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question