Search found 1124 matches

by FanaticGuru
Yesterday, 15:29
Forum: Tutorials
Topic: MS Office COM Basics
Replies: 107
Views: 65007

Re: MS Office COM Basics

When passing text to bookmarks in Microsoft Word, I am unable to send line feeds using `n. Is there any way to send text with carriage returns or line feeds? Chr(11) is newline, Chr(13) is new paragraph. Something like this: .InsertAfter("Stuff goes here" Chr(11) "then st...
by FanaticGuru
18 Jul 2018, 19:34
Forum: Ask For Help
Topic: Seeking Advice on Best Approach for Email Handling with Attachments
Replies: 20
Views: 300

Re: Seeking Advice on Best Approach for Email Handling with Attachments

For something like this to work Headers[A_Index] would need to contain a column letter like "B" but the way you populated the array it will probably contain a header name like "Date". Would my line of code above work? Columns[A_Index] := Chr(64+A_Index) If you want to us...
by FanaticGuru
18 Jul 2018, 16:14
Forum: Ask For Help
Topic: Seeking Advice on Best Approach for Email Handling with Attachments
Replies: 20
Views: 300

Re: Seeking Advice on Best Approach for Email Handling with Attachments

FanaticGuru, Thank you. However... finding the name of the column headers wasn't really what I was asking about. I am already doing that. It was not about finding the name of the column headers, it was about finding the column that a header is in. With that ability, you don't really need an array w...
by FanaticGuru
18 Jul 2018, 15:34
Forum: Ask For Help
Topic: Seeking Advice on Best Approach for Email Handling with Attachments
Replies: 20
Views: 300

Re: Seeking Advice on Best Approach for Email Handling with Attachments

Unfortunately, having the name of the column doesn't quite crossover neatly when using .Range with arrays... or maybe it does and I'm not coding the array correctly. If so, by all means please correct me. :D CellDate := "07/18/2018" FormatTime, CellDate, M/d/yyyy oWB.Sheets(Sht).Range(Hea...
by FanaticGuru
17 Jul 2018, 11:34
Forum: Ask For Help
Topic: Seeking Advice on Best Approach for Email Handling with Attachments
Replies: 20
Views: 300

Re: Seeking Advice on Best Approach for Email Handling with Attachments

What's the best approach to using the Header Names of a spreadsheet rather than the R1C1 convention in Excel (using ComObjCreate)? I'm asking because the columns in this spreadsheet can / do get shifted around by any one of several users, and I am (was) attempting to place strings in specific colum...
by FanaticGuru
06 Jul 2018, 15:15
Forum: Ask For Help
Topic: Seeking Advice on Best Approach for Email Handling with Attachments
Replies: 20
Views: 300

Re: Seeking Advice on Best Approach for Email Handling with Attachments

All that aside it sounds like there is just something wrong with your path. You might do a MsgBox % dFilename right before that line to make sure the path looks right. Did that... still same error unless Excel is open. (This is on a Windows 7 machine if that has anything to do with it.) I don't kno...
by FanaticGuru
06 Jul 2018, 15:01
Forum: Ask For Help
Topic: Using associative arrays here?
Replies: 7
Views: 207

Re: Using associative arrays here?

CreatePixel(Color, Handle) { VarSetCapacity(BMBITS, 4, 0), Numput("0x" . Color, &BMBITS, 0, "UInt") hBM := DllCall("Gdi32.dll\CreateBitmap", "Int", 1, "Int", 1, "UInt", 1, "UInt", 24, "Ptr", 0, "Ptr") hBM ...
by FanaticGuru
06 Jul 2018, 13:09
Forum: Ask For Help
Topic: Seeking Advice on Best Approach for Email Handling with Attachments
Replies: 20
Views: 300

Re: Seeking Advice on Best Approach for Email Handling with Attachments

Question: In my current method to access the cells in a workbook, am I forced to have that workbook open in Excel? oWorkbook := ComObjGet(dFilename) I'm getting some kind of error saying that I'm using an invalid extension in the filename if I don't have the workbook open, and I wasn't sure if this...
by FanaticGuru
05 Jul 2018, 16:01
Forum: Ask For Help
Topic: Seeking Advice on Best Approach for Email Handling with Attachments
Replies: 20
Views: 300

Re: Seeking Advice on Best Approach for Email Handling with Attachments

I'm still trying to sort out how to approach the inbound requests from Outlook. There are two primary functions that I need to work through. One for handling the 'sign me up' requests for receiving all future sermons via email, and another to handle the 'one-off' sermon requests. I supposed that fo...
by FanaticGuru
04 Jul 2018, 01:44
Forum: Ask For Help
Topic: Seeking Advice on Best Approach for Email Handling with Attachments
Replies: 20
Views: 300

Re: Seeking Advice on Best Approach for Email Handling with Attachments

The cell that I'm referencing in my previous comment (in regard to the variable %RecipientFirstName%) is: Thank you %RecipientFirstName% for requesting today`'s sermon. We hope it brings you and your loved ones closer to the Will of God. May the Lord Bless and Keep you this day. I'm hoping to work ...
by FanaticGuru
03 Jul 2018, 16:59
Forum: Ask For Help
Topic: AutoCAD_Get
Replies: 3
Views: 114

Re: AutoCAD_Get

https://autohotkey.com//boards/viewtopic.php?f=6&t=45822 the Ppt_Get is AMAZING, could someone make a AutuCAD_Get? thanks Did you try just connecting directly to AutoCAD? ; Create AutoCAD Application object of currently running AutoCAD program acApp := ComObjActive("AutoCAD.Application&quo...
by FanaticGuru
02 Jul 2018, 13:50
Forum: Ask For Help
Topic: transform XML object to AHK object
Replies: 8
Views: 223

Re: transform XML object to AHK object

Your XPath expression would be something like this: /breakfast_menu/food[@style = "meal"]/price . If instead you want the entire food node where the style is "meal", then just chop off the "/price". An example of using XPath with the above XML data and printXML functio...
by FanaticGuru
01 Jul 2018, 15:11
Forum: Ask For Help
Topic: Seeking Advice on Best Approach for Email Handling with Attachments
Replies: 20
Views: 300

Re: Seeking Advice on Best Approach for Email Handling with Attachments

I don't know exactly what you want but the answer is probably yes, AHK can do that. Yes, AHK can send messages through Outlook with attachments. Yes, AHK could send those messages based on a list of addresses in Excel. Yes, AHK could custom the emails with names and what file is attached and make th...
by FanaticGuru
01 Jul 2018, 14:40
Forum: Ask For Help
Topic: Excel COM: Copy values from 2 sheets?
Replies: 3
Views: 66

Re: Excel COM: Copy values from 2 sheets?

I need your help. My aim is to copy data from two sheets of an Excel table (which is active) and to export them to a text file. The good news: It almost works. The bad news: It seems there is a problem with changing the sheet. It doesn't copy the values of sheet 2. Does sheet2 have to have a specif...
by FanaticGuru
29 Jun 2018, 12:03
Forum: Ask For Help
Topic: how to call excel com to insert a image to a excel file ? Topic is solved
Replies: 5
Views: 131

Re: how to call excel com to insert a image to a excel file ? Topic is solved

Hi bro, tnx for your code, works for me. The image can insert well. One more question where can learn the com api, so I can make the code by myself in the future. Tnx again bro ~ MSDN Microsoft is a good start for reference. For example this link shows the Shape object. https://msdn.microsoft.com/e...
by FanaticGuru
28 Jun 2018, 15:10
Forum: Ask For Help
Topic: how to call excel com to insert a image to a excel file ? Topic is solved
Replies: 5
Views: 131

Re: how to call excel com to insert a image to a excel file ? Topic is solved

As the title said, I found a post before, which said PasteSpecial can do the job. And I try the code like this: error occur : cant get the PasteSpecial property. So any other way to make it? FileSelectFile, Path Xl := ComObjCreate("Excel.Application") Xl.Workbooks.Open(Path) ;open an exis...
by FanaticGuru
27 Jun 2018, 16:18
Forum: Ask For Help
Topic: transform XML object to AHK object
Replies: 8
Views: 223

Re: transform XML object to AHK object

I want to read an XML file and extract data from it. Is there a way to get the data into a AHK array or object? So far I was trying this: FileRead, XMLText, % Path Xml := loadXML(XMLText) ObjTree(XML) Return loadXML(ByRef data) { o := ComObjCreate("MSXML2.DOMDocument.6.0") o.async := fals...
by FanaticGuru
26 Jun 2018, 13:04
Forum: Ask For Help
Topic: Help Retrieving Specific Text From Api (Bible Verse) Topic is solved
Replies: 5
Views: 130

Re: Help Retrieving Specific Text From Api (Bible Verse) Topic is solved

Here are two: How can they be taken? Jn1:1 {"query":"Jn1:1","canonical":"John 1:1","parsed":[[43001001,43001001]],"passage_meta":[{"canonical":"John 1:1","chapter_start":[43001001,43001051],"chapter_end&q...
by FanaticGuru
26 Jun 2018, 00:43
Forum: Ask For Help
Topic: getElementsByTagName + href
Replies: 4
Views: 115

Re: getElementsByTagName + href

Hi, Thank you for your answer. I tried to use it but it never enter inside the if (element.getAttribute("className") == "AAA"). The condition seems to be never true, but with my previous code it was working. Do you have any other ideas ? <div class="AAA" id="AAAid...
by FanaticGuru
25 Jun 2018, 14:39
Forum: Ask For Help
Topic: Help Retrieving Specific Text From Api (Bible Verse) Topic is solved
Replies: 5
Views: 130

Re: Help Retrieving Specific Text From Api (Bible Verse) Topic is solved

Wow, thanks for the help -- I was not familiar with the Needle function at all. However, it does give me an error if I request text with quotations (" " )in it, and it does not return verses that contain quotations in it. Hosea 1:1-3 The word of the LORD that came to Hosea, the son of Bee...

Go to advanced search