Search found 1064 matches

by FanaticGuru
Yesterday, 19:29
Forum: Ask For Help
Topic: Read and forward mail in an IMAP inbox
Replies: 19
Views: 223

Re: Read and forward mail in an IMAP inbox

That example is pretty much dead on what I'm using, I must have copied it from another thread. But if I read it right, it's using the same user account for both the folder check and the send function. In my effort, it's the send function that's biting me, as I'm doing the folder contents check on a...
by FanaticGuru
Yesterday, 14:27
Forum: Ask For Help
Topic: Put text in Clipboard as Hyperlink to paste in Excel/Outlook
Replies: 2
Views: 35

Re: Put text in Clipboard as Hyperlink to paste in Excel/Outlook

Hi, I wonder if there is a way to put text in Clipboard as Hyperlink to paste in Excel/Outlook You just need to put HTML code on clipboard and it will paste as a link in Excel. Title := "programmers" Link := "http://programmers.stackexchange.com/" Clipboard = ( <html> <a href=&q...
by FanaticGuru
Yesterday, 13:45
Forum: Ask For Help
Topic: Read and forward mail in an IMAP inbox
Replies: 19
Views: 223

Re: Read and forward mail in an IMAP inbox

catching up, I do have the items being found in the relevant folder, I can see each item via a msgbox that I have in the for loop. The problem is that the IMAP server I'm checking doesn't support SMTP, so I can't forward the message. I have been trying to use SendUsingAccount to send it out from a ...
by FanaticGuru
Yesterday, 13:27
Forum: Ask For Help
Topic: Delete PDF Pages through Adobe COM
Replies: 15
Views: 260

Re: Delete PDF Pages through Adobe COM

I'm looking to insert a blank page between each page in a PDF. I have an idea, but not sure on how to specify where the blank page should be placed. The structure of my idea is having a PDF with one blank page and insert that page in the file I want to have blank pages in. Any idea on how to do thi...
by FanaticGuru
23 May 2018, 17:39
Forum: Ask For Help
Topic: Excel to Variable - seeking more efficient way Topic is solved
Replies: 6
Views: 115

Re: Excel to Variable - seeking more efficient way Topic is solved

It is not uncommon for my company to have multiple excel files open. With that in mind, my current script obtains the specific excel title needed and stores it as a variable using WinActivate, %EXCEL% to pull the appropriate one. Can I add the title into this somewhere? Also - Is there a way to obt...
by FanaticGuru
23 May 2018, 12:33
Forum: Ask For Help
Topic: how to read excel column and put it in array and send it
Replies: 2
Views: 53

Re: how to read excel column and put it in array and send it

; Create a connection between AHK and an open active Excel file xlApp := ComObjActive("Excel.Application") Columns := ["A","D","F"] Data := {} ; Get all cell values in columns and put in an array for Index, Column in Columns for xlCell in xlApp.ActiveSheet.Us...
by FanaticGuru
22 May 2018, 21:07
Forum: Gaming
Topic: [Game] AHKBAN a Boxxle (Sokoban) clone
Replies: 4
Views: 96

Re: [Game] AHKBAN a Boxxle (Sokoban) clone

I played the first 7 levels and I like it. I have not seen this puzzle before. When I have more time, I will definitely see how far I can go.

Nice job implementing it also. It plays fine without any problems that I noticed. Responsive movement. Good job.

FG
by FanaticGuru
22 May 2018, 16:10
Forum: Ask For Help
Topic: Excel to Variable - seeking more efficient way Topic is solved
Replies: 6
Views: 115

Re: Excel to Variable - seeking more efficient way Topic is solved

Thank you for the response. I will try to poke through this and try to figure it out. But I will be honest, this all looks amazingly foreign to me =D Yes, this is accessing Excel in a totally different way than through the clipboard. COM allows AutoHotkey to communicate directly with Excel as one p...
by FanaticGuru
21 May 2018, 23:42
Forum: Ask For Help
Topic: Excel to Variable - seeking more efficient way Topic is solved
Replies: 6
Views: 115

Re: Excel to Variable - seeking more efficient way Topic is solved

xlApp := ComObjActive("Excel.Application") ; one cell to one variable HAWB := xlApp.Range("A1").Value MsgBox % HAWB Data := {} ; Get all cell values in column A and put in an array for Cell in xlApp.ActiveSheet.UsedRange.Columns("A").Cells Data.Push(Cell.Value) ; Displ...
by FanaticGuru
18 May 2018, 15:21
Forum: Ask For Help
Topic: Excel COM Topic is solved
Replies: 4
Views: 84

Re: Excel COM Topic is solved

I'm trying to find the equivalent of xlToRight for xlToLeft. Does anyone know what number should be defined as xlToLeft, and also where this number comes from? I'm trying to get to column A. Another way is while you are in Excel, you can hit Alt-F11 to open the Visual Basic Editor, then hit Ctrl-G ...
by FanaticGuru
18 May 2018, 00:16
Forum: Ask For Help
Topic: Help with Find method for excel (COM) Topic is solved
Replies: 2
Views: 61

Re: Help with Find method for excel (COM) Topic is solved

Hello, In part of my script I am trying to find cells with specific format, but the "format" argument of Find doesn't seem to do anything -- the method finds any cell with specified value, even though the format doesn't match. Here's my code: xl := ComObjActive("Excel.Application&quo...
by FanaticGuru
17 May 2018, 15:53
Forum: Ask For Help
Topic: Read and forward mail in an IMAP inbox
Replies: 19
Views: 223

Re: Read and forward mail in an IMAP inbox

I don't know anything about the software involved but you could try: for _, Item in olSubfolder.Items ;instead of: for Item in olSubfolder.Items Just for the record for Item in olSubfolder.Items is correct. This is the way for works with most COM objects which are collections where the key is the d...
by FanaticGuru
16 May 2018, 23:00
Forum: Ask For Help
Topic: [help] : insert into last row of excel sheet Topic is solved
Replies: 4
Views: 102

Re: [help] : insert into last row of excel sheet Topic is solved

Thank you for the help Unfortunately it does not work with me, it switch to excel windows but nothing inserted I can tell you that it works for me on multiple computers using different versions of Excel. Nothing about the script will cause "it switch to excel windows" so maybe you are att...
by FanaticGuru
16 May 2018, 14:51
Forum: Ask For Help
Topic: Code cleanup - PowerPoint COM
Replies: 8
Views: 122

Re: Code cleanup - PowerPoint COM

Here is two examples of techniques I would use. ; init array Replacements := {} Replacements.Push("Digital Advertising Performance | Ford") Replacements.Push("Digital Advertising Performance | Lincoln") Replacements.Push("Website Performance Insights") ; loop array for ...
by FanaticGuru
16 May 2018, 14:00
Forum: Ask For Help
Topic: [help] : insert into last row of excel sheet Topic is solved
Replies: 4
Views: 102

Re: [help] : insert into last row of excel sheet Topic is solved

hello, i have an excel filename "E:\h\ahk\off.xlsm" i want to paste the value of variable %var1% into the empty row next to the last "used" row of column A ,for example column A has 6 used row, i want to paste it into the row 7 of column "A" (" A7 " cell) the...
by FanaticGuru
16 May 2018, 13:39
Forum: Ask For Help
Topic: Help convert this VBScript to AHK
Replies: 7
Views: 147

Re: Help convert this VBScript to AHK

It is mostly the same as before except with FanaticGuru's contributions added with a few changes (specifically, using the WinWait command instead of the query process loop, using PID with ExecQuery instead of Process Name and using the WinKill command instead of Terminate). objGameInstance := ComOb...
by FanaticGuru
15 May 2018, 17:15
Forum: Ask For Help
Topic: Help convert this VBScript to AHK
Replies: 7
Views: 147

Re: Help convert this VBScript to AHK

I am not very familiar with COM Objects or how AHK uses them so I can't currently figure out how to make three of the commands work in AHK syntax. Here is an equivalent example to some of the tricker VBA code: cName := "notepad.exe" objWMIService := ComObjGet("winmgmts:") Loop {...
by FanaticGuru
15 May 2018, 13:04
Forum: Ask For Help
Topic: Help convert this VBScript to AHK
Replies: 7
Views: 147

Re: Help convert this VBScript to AHK

I can see how most of the commands can be converted to AHK equivalents but I'm puzzled on what exactly these lines are doing: SET objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\\.\root\cimv2") commandLine = objInstance.CommandLine I'm assuming the second line is gra...
by FanaticGuru
14 May 2018, 11:55
Forum: Ask For Help
Topic: COM script help, copy and paste from excel to different program
Replies: 2
Views: 52

Re: COM script help, copy and paste from excel to different program

Here is an example of how to loop through all the cells in Columns A and B. MyFilePath := A_Desktop "\PMU.xlsx" try oExcel := ComObjActive("Excel.Application") ; Get the active Excel application object if an instance of Excel is open. catch { oExcel := ComObjCreate("Excel.Ap...
by FanaticGuru
14 May 2018, 11:42
Forum: Ask For Help
Topic: Externally calling a function from running AHK script
Replies: 7
Views: 102

Re: Externally calling a function from running AHK script

You can use ObjRegisterActive linked below: https://autohotkey.com/boards/viewtopic.php?t=6148 This will allow you to register an AutoHotkey object with Windows as a COM object. Then any program that can access COM objects (most popular Windows programming languages can) will be able to access the m...

Go to advanced search