AutoHotkey Community

It is currently May 27th, 2012, 1:49 am

All times are UTC [ DST ]




Post new topic Reply to topic  [ 296 posts ]  Go to page Previous  1 ... 9, 10, 11, 12, 13, 14, 15 ... 20  Next

Should this be continued?
Poll ended at June 18th, 2008, 11:34 pm
Yes 93%  93%  [ 14 ]
No 7%  7%  [ 1 ]
Total votes : 15
Author Message
 Post subject:
PostPosted: January 7th, 2010, 5:24 am 
Offline
User avatar

Joined: December 21st, 2007, 3:14 pm
Posts: 3826
Location: Louisville KY USA
you are correct it doesnt work correctly in that it generates an error i and sinkfaze both use com_error(0) prior to calling it which works fine doesnt to me seem important enuff to worry about it as its the only instance i have ever seen of such a problem

_________________
No matter what your oppinion Please join this discussion
Formal request to Polyethene
Image


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: January 7th, 2010, 5:56 am 
Offline

Joined: March 19th, 2007, 12:43 am
Posts: 532
Ah, so com_error(0) works like "On Error Resume Next" in VB?


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: January 7th, 2010, 3:11 pm 
Offline
User avatar

Joined: December 21st, 2007, 3:14 pm
Posts: 3826
Location: Louisville KY USA
no but yea

_________________
No matter what your oppinion Please join this discussion
Formal request to Polyethene
Image


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: January 9th, 2010, 1:40 am 
Offline

Joined: March 19th, 2007, 12:43 am
Posts: 532
Holy crap, i just realized i can run VBA code through this library!!!
Code:
COM_Init()

objExcel := COM_GetActiveObject("Excel.Application")
COM_Invoke(objExcel, "Run", "Book1!test")


I can finally have my VBA apps run through exe !!!!!!!!!!!!!!! This is so awesome!


Report this post
Top
 Profile  
Reply with quote  
PostPosted: January 20th, 2010, 5:47 pm 
I search it some hour but not find any of them:
1. Are there any method to Copy a full Worksheet then paste is as a new Worksheet? (In the same Workbook)
2. Are there any method, to activate a Cell?
3. Are there any method, to instert or delete rows (and the instert is like the original insert funkcion, so get up the style of the upper row.)

The first, and the third is really need me, (the second only for the third to know where create the new row.)

Please if somebody know the answer, then wrote it down. If there arent any of them, then tell me it is able to create or not.

I'm really obliged if i get these snippets. So if somebody can, please help. Its important for me.


Report this post
Top
  
Reply with quote  
 Post subject:
PostPosted: January 22nd, 2010, 3:05 pm 
Offline

Joined: November 19th, 2009, 6:23 pm
Posts: 163
Location: Florida
removed


Last edited by frescalus on January 25th, 2010, 6:33 pm, edited 1 time in total.

Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: January 22nd, 2010, 3:42 pm 
Offline
User avatar

Joined: March 19th, 2008, 12:43 am
Posts: 5480
Location: the tunnel(?=light)
GetOutlook() does not access the Application object so I think we're missing something. What is the entire code you're working with?

_________________
Image
Try Quick Search for Autohotkey or see the tutorial for newbies.


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: January 22nd, 2010, 4:14 pm 
Offline

Joined: November 19th, 2009, 6:23 pm
Posts: 163
Location: Florida
removed


Last edited by frescalus on January 25th, 2010, 6:33 pm, edited 1 time in total.

Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: January 22nd, 2010, 5:22 pm 
Offline

Joined: February 12th, 2007, 7:54 am
Posts: 2462
What's the point of your post? I've never mentioned Outlook in the post of GetNativeOM, it was only your imagination that it would work for Outlook even regardless of the control chosen, which you arbitrarily picked up RichEdit20W for, and you just proved that it was an illusion. GetNativeOM will only work for Excel, PowerPoint, and Word, at least up to Office 2003.


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: January 22nd, 2010, 6:19 pm 
Offline

Joined: November 19th, 2009, 6:23 pm
Posts: 163
Location: Florida
removed


Last edited by frescalus on September 2nd, 2010, 4:10 pm, edited 1 time in total.

Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: January 23rd, 2010, 1:49 am 
Offline

Joined: February 12th, 2007, 7:54 am
Posts: 2462
If you just wanted to know about Outlook and GetNativeOM, you could simply have asked about it first. You should not provide a incorrect info: working in Office 2003 but not working in Office 2007 which was wrong. It'll mis-guide other members to possibly waste their precious time, well it already seemed so for sinkfaze.


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: January 25th, 2010, 2:23 pm 
Offline

Joined: November 19th, 2009, 6:23 pm
Posts: 163
Location: Florida
removed


Last edited by frescalus on September 2nd, 2010, 4:10 pm, edited 1 time in total.

Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: January 25th, 2010, 5:01 pm 
Offline
User avatar

Joined: March 19th, 2008, 12:43 am
Posts: 5480
Location: the tunnel(?=light)
frescalus, you're not trying to understand Sean's point at all. These functions are somewhat high end for what people can do with AHK, which means it requires a greater understanding of the inner workings of Office applications and the Visual Basic scripting language. Your assumption in creating GetOutlook(), while imaginative, demonstrated that you don't understand why the proper functions work (or why that method only works for certain Office apps). Bad code in the forums is more critical here than in other instances, and since you misused Sean's code (which implicates him as the author), he was understandably upset. If you want to experiment but lack the fundamental understanding, just ask but never assume. Nobody is unwilling to help, but you should expect that you need to know/be willing to learn about the inner workings of Office apps and VBScript.

_________________
Image
Try Quick Search for Autohotkey or see the tutorial for newbies.


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: January 25th, 2010, 6:35 pm 
Offline

Joined: November 19th, 2009, 6:23 pm
Posts: 163
Location: Florida
Removed content from both of my posts


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: February 10th, 2010, 6:46 am 
Offline

Joined: February 9th, 2010, 6:04 am
Posts: 3
Hi, can somebody help me?
It an method does not work and I cannot solve it unfortunately:

http://msdn.microsoft.com/en-us/library ... 11%29.aspx

Word_TextBox(Text){
Word := Word_Attach("A")
ActiveDocument := com_invoke(Word,"ActiveDocument")
Shape := com_invoke(ActiveDocument,"Shapes")
AddTextBox := com_invoke(Shape,"AddTextBox",Orientation:=msoTextOrientationHorizontal, Left:=100, Top:=100, Width:=300, Height:=200)

TextFrame := com_invoke(AddTextBox,"TextFrames")
TextRange := com_invoke(TextFrame,"TextRange")
Text := com_invoke(TextRange,"Text=",Text)

COM_Release(ActiveDocument)
COM_Release(Word)
COM_Release(Shapes)
COM_Release(AddTextBox)
}

Any help would be really appreciated thanks!


Last edited by Gabor on February 10th, 2010, 5:49 pm, edited 1 time in total.

Report this post
Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 296 posts ]  Go to page Previous  1 ... 9, 10, 11, 12, 13, 14, 15 ... 20  Next

All times are UTC [ DST ]


Who is online

Users browsing this forum: Bing [Bot] and 12 guests


You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Powered by phpBB® Forum Software © phpBB Group