• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1292
  • Last Modified:

Filemaker Pro DDE Command for Internet Explorer

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
tammyf
Asked:
tammyf
  • 6
  • 4
1 Solution
 
lesouefCommented:
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
 
tammyfAuthor Commented:
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
 
tammyfAuthor Commented:
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
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
tammyfAuthor Commented:
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
 
lesouefCommented:
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
 
tammyfAuthor Commented:
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
 
lesouefCommented:
Why would you use a send event if a rum command works?
0
 
tammyfAuthor Commented:
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
 
lesouefCommented:
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
 
tammyfAuthor Commented:
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
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now