AutoHotkey Community

[abcyourway]

Don't forget the Internet Explorer!
It would be much greater help than any other things.

[ahklerner]

[Guest]

[Sean]

Hi ahklerner,

You made me login. Thanks for starting up this great and big project.
And I'd like to contribute a little too. It'll use Excel as an example here, but I believe similar methods will also apply to other office applications.

There should exist a temporary excel file test.xls in A_Temp folder.

Yet another (inconvenient) method to load an office document:

[abcyourway]

[ahklerner]

that can be done with javascript (whch CAN be inserted into the IE) you can also get values of javascript vars. is there something you need to do that can not be accomplished that way?

maybe you have not seen this post: http://www.autohotkey.com/forum/viewtopic.php?t=25473
_________________

ʞɔпɟ əɥʇ ʇɐɥʍ

[Guest]

First, thank you for the script and your contriibutions.
I am not pushing you to do it right now.
I just wanted to mention it so that when you you find time, you could try.

And I really liked your javascript solution, really!

About IE_automation, yeah we can do it with javascript, vbscript, even with API Dllcall, right?
We can send keys to some windows and make hotkeys without Autohotkey.

The point is that I and hopefully many people want to do it with Autohotkey, not with API calling, not with vbscript, autoit script. Of course not with javascript^^;

Ok, you got started with Office Apps, so first thing is first thing.
Word, excel part I can understand, but powerpoint and access? who would automate them? Don't we have ADO-related fucntions here?

Anyway I hope I didn't sound like grumbling^^;
Thank you for the script, ahklerner.

[Guest]

@whom who's urging on him to make IE automation

i understand what you're talking about. but please listen me Wrapping the whole Office applications or part of them is not that easy or small job. have you ever look autoit's library for office automation? it's damn huge. it'll take long time. i agree that IE is more widely spreaded application. but as others say there's many other methods to interwork with IE though you don't like. by contrast. afaik there's no other way to do with MS office application atm except hardcoding with COM. automating MS Office has been dearest wish in the community. since you can do what you want atm would you please stop burden him with IE automation on MS Office thread?

[Krogdor]

Ooh, very nice... I've always been wondering about something like this for Word.

Although,

[n-l-i-d]

I found some helpful resources for Word:

Word Macros and VBA FAQ
How to speed up Word Automation by hiding the application (or Office automation in general)

[ahklerner]

[Laszlo]

Is there an easy way to get the character to the left of the insertion point in a Word document? For example
- find the caret position
- define a range consisting of one character
- retrieve the character in the range.

This should not disturb the selection or the clipboard (which is known no to work properly with AHK). Something like this would be essential for a keyboard manager script.

[aarondellis]

Thank you for this great information. Is it possible to read the contents of a cell in Excel?

[Laszlo]

It would be also nice to be able to handle (get, put) Unicode text, get the font and text attributes in the selection or at the insertion point.

Does someone have a list of methods supported by the COM interface to Word, like “Selection”, “Text”?

[ahklerner]

2 Laszlo:
Here is a link from msdn.
http://msdn.microsoft.com/en-us/library/aa272082%28office.11%29.aspx

I already have code for getting the font specs for the selection or the current ip.