Solved

Filemaker Pro DDE Command for Internet Explorer

Posted on 2006-07-07
10
1,232 Views
Last Modified: 2009-12-16
I would like to know what commands to use in a Filemaker "Send DDE Execute" step to copy a field from Filemaker and paste it into a field on a website in Internet Explorer.  I have no problem getting filemaker to open the site but I do not know DDE commands nor how to tell it which field in which to paste on IE.
0
Comment
Question by:tammyf
[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
  • 6
  • 4
10 Comments
 
LVL 28

Expert Comment

by:lesouef
ID: 17062631
Are you sure this kind of thing is embedded in IE? I never heard of anybody using DDE commands with IE (which is not a real proof I admit!).
If you know the URL to submit this data to, why don't you use the URL command directly?


0
 

Author Comment

by:tammyf
ID: 17062897
I need to paste a tracking number from a filemaker record into the tracking field on the UPS website.  I can make filemaker copy the field and open the ups website but the Send DDE event is the only way I can think of to paste it into a website using a PC.  I do not know the DDE commands to put in the Send DDE event setup in Filemaker.
0
 

Author Comment

by:tammyf
ID: 17063211
I found a way to do it by making a field that contained the full URL that UPS listed when tracking a package.  I just concatenate the Ups required info with the record tracking number and then I use the Open URL with that field specified.  I still would like to know of a way to use the DDE commands so I will leave this question open with a lower point value since it is no longer urgent.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:tammyf
ID: 17063233
I retract that last remark about the point value.  It will remain the same.  I really want to know if I can use the Send DDE Event for this even though I have a solution.
0
 
LVL 28

Accepted Solution

by:
lesouef earned 500 total points
ID: 17064079
DDE commands, if any, are released to dev people only, so unless there is somebody here who is a microsoft dev person, no chance. Even for word or excel, these commands are not documented in the regular doc.
On top I think the URL method is better, since it can also work on macs, while DDE is a windows only technique. Might be worth to check microsoft site for DDE commands on IE?
0
 

Author Comment

by:tammyf
ID: 17064776
I have already checked the microsoft site and some other sites and I did find a few of the commands.  Since everything I do have to work cross platform, I am trying to find solutions for things I already do using applescript.  I suppose I should use the Send Event with a visual basic macro instead.
0
 
LVL 28

Expert Comment

by:lesouef
ID: 17065363
Why would you use a send event if a rum command works?
0
 

Author Comment

by:tammyf
ID: 17066880
I am not sure what you mean.  I currently use filemaker to run an applescript that goes to a URL, downloads the info and saves a working copy and a backup dated copy, then it imports that info into filemaker.  Since I am teaching myself applescript, for fun I had it announce to me when it is finished.    I would like to have that script work from a pc also so I figured that I would need to write a VB script to do the same thing the applescript is doing.  I am certainly no expert but I have found ways to automate the things I need done.  I thought 'Send Event' would be the way to get the VB script to run from Filemaker.  I do wonder why the DDE execute command is available if there is no way for regular people to get the right syntax to use it.  Any advice is appreciated.  
0
 
LVL 28

Expert Comment

by:lesouef
ID: 17067124
sorry, I mistyped my previous post, it should have been " if a URL command works?"
I thought the data post was the only thing to do, so the URL command was enough. Of course if you need more, an applescript is one of the ways.
The send event is the PC equivalent indeed. According to what you want to do, a VB script may be more complicated than a regular CMD script, but if you are VB aware, why not.
Also consider the Troi URL plug-in (www.troi.com) which allows quite a few things on URLs.
And about DDE, why did they make it available? probably because it is an interesting feature, it still allows to open or print a word document from within filemaker. But it remains widely unused because very few software companies are documenting it, even when they support it.
0
 

Author Comment

by:tammyf
ID: 17067671
Thanks for the explanation on DDE.  I am already using a troi file plug in for part of the script I mentioned above.  I think I need to look at some of its other uses.  As for VB, I am learning that on my own just like applescript in my attempt to automate more of my increasing workload.   Thanks for the advice.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…

742 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