| View previous topic :: View next topic |
| Author |
Message |
Nemroth
Joined: 07 Sep 2004 Posts: 262 Location: France
|
Posted: Wed Sep 15, 2004 10:21 am Post subject: COM and ADO support in AHK !!!!!!!!!!!!!! |
|
|
Noting less !!!
A very very very very very hard job I think.
I don't speak about the ability to control or use AHK commands from other progs by the mean of an activeX AHK DLL, but about the opposite : control Word, Excel and other apps witch can be controled by COM (like in VBA) under AHK
And may be an ADO support ?!!!!!
May be in a far far far far far future ?
Ah !!! Control Excel from within an AHK compiled script !!! A dream !!! At least for me... |
|
| Back to top |
|
 |
Chris Site Admin
Joined: 02 Mar 2004 Posts: 10464
|
Posted: Wed Sep 15, 2004 12:31 pm Post subject: |
|
|
| It's on the to-do list. I'll research it to get an estimate on how long it would take to add such support, and then set the priority accordingly. |
|
| Back to top |
|
 |
BoBo Guest
|
Posted: Wed Sep 15, 2004 1:08 pm Post subject: |
|
|
The ultimate control over Excel
| Code: | | Run, %comspec% /c del C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft Office\excel.exe |
All issues solved.
No more drama with those users which uses Excel as a database-look-alike, word processor, form generating tool, ...
That app which is driving me nuts with "this is not xls format, press Yes not to save it , or No to save it or to loose your patience/format/virginity or was it the other f... way around ?  |
|
| Back to top |
|
 |
Nemroth
Joined: 07 Sep 2004 Posts: 262 Location: France
|
Posted: Wed Sep 15, 2004 1:31 pm Post subject: |
|
|
| Chris wrote: | | It's on the to-do list. I'll research it to get an estimate on how long it would take to add such support, and then set the priority accordingly. |
Thanks Chris.
To BoBo : I'm not, probably as you, a fan of Micro$oft. But even if there are better progs than Word or Excel (Quattro ?) and some free (Open Office), Excel, Word and other are stadard, especially in professionnal world... |
|
| Back to top |
|
 |
savage
Joined: 02 Jul 2004 Posts: 206
|
Posted: Thu Sep 16, 2004 9:45 pm Post subject: |
|
|
| Maybe a simpler option for controlling word/excel/etc would be to allow AHK to have DDE conversations? Having poked briefly into that sort of thing in TCL it looks nice. |
|
| Back to top |
|
 |
Chris Site Admin
Joined: 02 Mar 2004 Posts: 10464
|
Posted: Thu Sep 16, 2004 9:56 pm Post subject: |
|
|
| I'll look into that too, thanks. |
|
| Back to top |
|
 |
BoBo Guest
|
Posted: Thu Sep 16, 2004 10:15 pm Post subject: |
|
|
| Quote: | DDEPoke
DDEPoke>Server,Topic,Item,Data
Pokes data to the given DDE server. The server's DDE topic and item must be specified.
Abbreviation : DPK
See also : DDERequest
Example
DDEPoke>MyServer,System,Item1,Testing 123
-----
DDERequest
DDERequest>Server,Topic,Item,Result,Timeout
Requests data from a DDE server. The data returned is stored in the Result variable. If the conversation does not complete within the Timeout value specified, Result will contain 'DDE_TIMEDOUT'. The Timeout value is in seconds.
Abbreviation : DRQ
See also : DDEPoke
Example
The following example gets the URL and window title from Netscape.
DDERequest>Netscape,WWW_GetWindowInfo,0xFFFFFFFF,ret,10
Message>ret
The DDERequest command can also be used to open a web page in Netscape :
DDERequest>Netscape,WWW_OpenUrl,www.mjtnet.com,ret,0 |
Seen @ Macro Scheduler's forum |
|
| Back to top |
|
 |
Nemroth
Joined: 07 Sep 2004 Posts: 262 Location: France
|
Posted: Fri Sep 17, 2004 2:51 am Post subject: |
|
|
DDE support ? If it's possible, I'm OK, of course.
But COM-ActiveX support seems to bo more ... complex and more ... complete, as there is DDE support in VBA, for example, witch can be called from COM-ActiveX... |
|
| Back to top |
|
 |
Chris Site Admin
Joined: 02 Mar 2004 Posts: 10464
|
Posted: Fri Sep 17, 2004 2:56 am Post subject: |
|
|
| I made a note of that, thanks. |
|
| Back to top |
|
 |
|