AutoHotkey Community

its ok if i want create a method in com.ahk
but i want use current com_invoke

i understand thats a stupid method (resumenext), but i would not copy the big method com_invoke just to don't show msgbox ...
just a noob method because i'm afraid to do something into com_invoke



i haven't read all post, but i have seen the copy (so move too) sheet method from your link



i think its the code to add a sheet into defined position, but i haven't understand : "The code in that thread is the exact one which you have to resort to when the following code will not work for you.", sorry -_-


thanks for all, specially to Sean

n-l-i-d: i'm too busy to read it now, but first line are interested

No, you didn't/don't need new functions. Just call COM_Error(0), afterwards no error message box will ever pop up.
Just use/adopt this code to your need. Yes, this code will add a new sheet after the last one. Move is similar.

thank you, all works fine now

i haved updated my last message with excel.com.ahk added code.

[EDIT]
oh ! , i don't understand param "-0" would mean

and about "+", i know the COM.AHK post:


but i don't see the difference with "+" or without "+", can you have a simple method un vbs/vba and the adapter method un ahk (with "+") please?
[/EDIT]


[EDIT]
i have found how change font style:
Style have been test with bold and italic (if you use bold then italic, the text will be bold-italic)

Excel_StyleFont("A", 1, "Bold",1) set Bold = true
Excel_StyleFont("A", 1, "Bold",0) set Bold = false
Excel_StyleFont("A", 1, "Bold",?) i don't know if the fourth param can have other value



i don't know how change color, color function show error msg
and its the same if i try to change background color of a cell ("Interior")


[/EDIT]

Without the prefix "+", the numeric parameter will be interpreted just as a 32-bit integer, not as an object.
For example, "0" will be just an integer zero, "+0" will be Nothing in VB. BTW, "-0" will be NULL in VB.
I suppose now you got the picture needed to code with COM_Invoke().

thanks

but i don't found how i can change the background color
functions color, background, color-background isn't known

[EDIT]
i have found it:

to change background color:
Excel_StyleCell("A", 1, "Color","AB12F5")


[/EDIT]

How to convert the VBA code like above to COM expression?

Is it correct? Anyway read the documentation, all are there.
http://msdn.microsoft.com/en-us/library/bb214129.aspx

Thx. That's the Excel macro I copied.

According to the msdn

This can saveas correctly. But I have to change the file format, so I write:

It throw a error. why?

MSDN syntax:
expression.SaveAs(Filename,FileFormat,Password,WriteResPassword,ReadOnlyRecommended, CreateBackup, AccessMode, ConflictResolution, AddToMru,TextCodePage, TextVisualLayout)

My code:

You have to use a number for that: XlFileFormat.

I would like to use AutoHotKey to run some VBA in Outlook. From searching this forum it looks like the best way to do this is through use of the COM library. My initial problem, as I look to try and write some AHK code to do this is that I'm not sure how to determine that a message window has focus before I execute the VBA. Any suggestion?

Thanks,
Christopher

Thank you for these! Any plans on finishing the Access functions? I'd be grateful!

I cant imagine many peices of VBA that require focus in relation to Outlook but setting focus would depend entirely on what your setting focus on


@ Astrognaw look up ADO in the forum

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

If you're determined to do through COM.ahk, you may consider to do the job entirely in it, i.e., may translate the VBA code into AHK.

Is there any way to retrieve the pattern color from a cell in excel?

I think Cells.Interior.ColorIndex will return the colour currently filling the cell.

_________________
There are 10 kinds of people in the world. Those who understand binary and those who don't.