Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

IconAuthor 7.5 to Excel commucations

Status
Not open for further replies.

fiserman

Technical User
Oct 16, 2000
1
US
Hello, I have already ask Peter Norton this question, before
I found the Authorware listing/thread.

Problem: I'm currently trying to use the DDE(Dynamic Data Exchange)icon to communicate with Excel spreadsheet to insert values into the data cells. In order to do so
I must use several DDE Icons. I cannot get the channel
parameter to work. I get the following errors. 31060, and 31064. Also via the Program Icon I am able to get Excel to Run, but will not open the specified file "pedx.txt".
If you need more detail let me know.

Example of Icon configuration:

The first DDE Icon in the string parameter should be:
Commmand=initiate
Channel= empty for the initiate command
Parameters=EXCEL,System
Time limit=10
Result variable=@channel1

Program Icon
Program=EXCEL
Window Size=Full Screen
Snapshot=Yes
Wait until Done?=Yes

The second DDE Icon in the string parameter should be:
Commmand=execute
Channel=@channel1
Parameters=[open("f\excel\pedx.txt")]
Time limit=10
Result variable=@load

Do think you can help me?

Thank you.

[sig][/sig]
 
Go to ftp://ftp.click2learn.com/pub/iconauthor/samples/ and download the ddeexcel.zip file 33KB 1/9/1998 for a sample application has you Launch/Run Excel.exe, Browse to a file which is then opened in Excel. You enter a Row and Column value such as R2C4 and a value. DDE icons include Poke, Print, Save commands. FYI Click2Learn used to be Asymetrix who bought out Aimtech which ended IconAuthor. You can get to the same FTP site using: ftp://ftp.asymetrix.com/pub/iconauthor/samples/
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top