Re: DDE - Dynamic Data Exchange
Ken Ray wrote: Where is this old Externals Collection for Windows? I don't see it on runrev.com. OK is this it? http://www.xworlds.com/metacard/external.htm ? I found it in the list archives. Maybe it should be added to the runrev.com site? Roger Kingston wrote: Thanks Ken - I found it and it works! It's at: http://www.xworlds.com/metacard/contributorfiles/ext10final.sit Ken Ray Sons of Thunder Software ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: DDE - Dynamic Data Exchange
Where is this old Externals Collection for Windows? I don't see it on runrev.com. OK is this it? http://www.xworlds.com/metacard/external.htm ? I found it in the list archives. Maybe it should be added to the runrev.com site? It's at: http://www.xworlds.com/metacard/contributorfiles/ext10final.sit Ken Ray Sons of Thunder Software Email: [EMAIL PROTECTED] Web Site: http://www.sonsothunder.com/ ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: DDE - Dynamic Data Exchange
Does anyone have examples of how I can execute VBA code via DDE from Revolution? Well, here's how you communicate via VBA from something like Excel to Revolution once it has been registered as EXT by the Externals Collection: Private Sub CommandButton1_Click() Dim tVal as Long tVal = Application.DDEInitiate(EXT,myTopic) Application.DDEExecute tVal, myCommand) End Sub In the Externals collection, there are two parameters that are passed to the extDDEexecuteMsg handler - a topic and a command. Here's how it looks trapping it in Rev: on extDDEexecuteMsg pTopic, pCommand switch pTopic case myTopic answer Command is: pCommand break case otherTopic -- do something else break end switch end exteDDEexecuteMsg Hope this helps, Ken Ray Sons of Thunder Software Email: [EMAIL PROTECTED] Web Site: http://www.sonsothunder.com/ ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
DDE - Dynamic Data Exchange
In a past life, I used to integrate Toolbook (Asymetrix) applications with Winword and EXCEL using DDE. This allowed me to pass data to and from MS documents and then remotely run macros in MS to format, chart or mail-merge, etc. This was extremely powerful and pretty reliable. Now I am an unrepentful RR convert (no going back!) can anyone suggest whether or not this, or something like it, can be achieved with RR? Regards Roger Kingston Omnibus Systems ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: DDE - Dynamic Data Exchange
RR can do DDE using the old Externals Collection available on the RunRev site, but my understanding is that DDE is to be phased out as of WindowsXP. Maybe someone more knowledgeable about MS/Windows can elaborate. Well, Scott, I'm currently running XP on a laptop, and the DDE external works just fine. I don't think DDE is phased out of XP, just deprecated. Eventually they'll phase it out, but for right now, it seems to still work. Ken Ray Sons of Thunder Software Email: [EMAIL PROTECTED] Web Site: http://www.sonsothunder.com/ ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: DDE - Dynamic Data Exchange
On Friday, November 15, 2002, at 11:49 AM, Scott Rossi wrote: RR can do DDE using the old Externals Collection available on the RunRev site, but my understanding is that DDE is to be phased out as of WindowsXP. Maybe someone more knowledgeable about MS/Windows can elaborate. In my project I need to write reports out in MS Word and MS Excel formats. Realbasic has a MS Office Automation plugin, but it was slow and buggy as $%^. It was of the reasons I switched to Rev. So I am currently putting VBA code to write the reports in an Excel template file, and the VBA code runs when I copy the Excel file into place and launch it. It's a tedious way to do it and VBA code is really hard to get right when you have to deal with lots of different MS Office versions. So, what is DDE and why is it being deprecated, and what is replacing it? Does anyone have examples of how I can execute VBA code via DDE from Revolution? Where is this old Externals Collection for Windows? I don't see it on runrev.com. OK is this it? http://www.xworlds.com/metacard/external.htm ? I found it in the list archives. Maybe it should be added to the runrev.com site? Many thanks in advance, Alex Rice, Software Developer Architectural Research Consultants, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution