Search found 604 matches

by FanaticGuru
Yesterday, 19:26
Forum: Ask For Help
Topic: Using COM to append comma delimited data
Replies: 8
Views: 119

Re: Using COM to append comma delimited data

FanaticGuru, I tried that, but it threw an error about the Range(rng).Offset phaleth on IRC told me you can't offset a range. I don't have time today, but later I think I'll work with this more. I just wanted to thank you for taking the time. I'm learning some things, I think! Thanks again, and I'l...
by FanaticGuru
Yesterday, 13:08
Forum: Ask For Help
Topic: Using COM to append comma delimited data
Replies: 8
Views: 119

Re: Using COM to append comma delimited data

This is the code I came up with. This does not work. So that means I am not understanding something. Someone please help. :) I want an array with 12 rows, and 1 column. SafeArray := ComObjArray(12, 12, 1) SafeArray[1, 0] := timeLog SafeArray[2, 0] := initLog SafeArray[3, 0] := meatLog SafeA...
by FanaticGuru
Yesterday, 12:26
Forum: Ask For Help
Topic: Outlook 2013 - How give text of mail object ?
Replies: 4
Views: 76

Re: Outlook 2013 - How give text of mail object ?

Below code will reply to the first email in selection. Emails := ComObjActive("Outlook.Application").ActiveExplorer.Selection ; get all emails selected Email_Reply := Emails.Item(1).Reply ; create reply to the first email Email_Reply.Display ; display the reply FG
by FanaticGuru
21 Jun 2017, 13:35
Forum: Ask For Help
Topic: Output list of all hotkeys used in ahk
Replies: 6
Views: 100

Re: Output list of all hotkeys used in ahk

"Hotkey Help - Display Active AHK Hotkeys and Hotstrings" could be what you are searching for. https://autohotkey.com/board/topic/93889-hotkey-help-display-active-ahk-hotkeys-and-hotstrings/ Try the sample an press Win+F1 for the Hotkey-Overview-Window I think you only have to change to c...
by FanaticGuru
20 Jun 2017, 16:44
Forum: Ask For Help
Topic: Link something like toaster popup to specific window
Replies: 3
Views: 62

Re: Link something like toaster popup to specific window

Below is an example of setting a window as a parent of a Gui. Win_Hwnd := WinExist("ahk_exe excel.exe ahk_class XLMAIN") ; Gui Create Gui, Font, s12, Bold Verdana Gui, Margin, 0, 0 Gui, Add, Button, xp yp Default gButton, CHILD BUTTON Gui, +LastFound +ToolWindow +AlwaysOnTop -Caption -Bord...
by FanaticGuru
19 Jun 2017, 18:48
Forum: Ask For Help
Topic: Phonebook Regex loop extraction
Replies: 5
Views: 90

Re: Phonebook Regex loop extraction

So, I know the proper regex: /d/d Information([^&]{20,50})/d/d Information But RegEx match would return only first match. How to get them all? I know there should be while pos and object, but I couldn't understand, how does that works. Any help would be appreciated, thank you! :D That needle is...
by FanaticGuru
19 Jun 2017, 14:48
Forum: Ask For Help
Topic: PDF file's current page No. ? Topic is solved
Replies: 3
Views: 91

Re: PDF file's current page No. ? Topic is solved

If you want to do it through COM along the lines of original post, you can try this: App := ComObjCreate("AcroExch.App") AVDoc := App.GetActiveDoc() AVPageView := AVDoc.GetAVPageView() MsgBox % AVPageView.GetPageNum It is important to realize that Acrobat uses a zero index for page numbers...
by FanaticGuru
16 Jun 2017, 18:34
Forum: Ask For Help
Topic: copy paste from one Excel to another, repeat
Replies: 2
Views: 45

Re: copy paste from one Excel to another, repeat

When dealing with Excel it is almost always better to use COM interface than key combinations. Xl := ComObjCreate("Excel.Application") ; Open Excel Xl.Visible := true ; Make Open Excel Visible Wb1 := Xl.Workbooks.Open(A_Desktop "\Test\One.xlsx") ; Open Excel Workbook Wb2 := Xl.Wo...
by FanaticGuru
15 Jun 2017, 13:19
Forum: Ask For Help
Topic: Webcam capture (fast)
Replies: 7
Views: 117

Re: Webcam capture (fast)

Here is Clipboard to File with GDI+: Clip2File(FileName := "Image.PNG", SavePath := "") { if !SavePath SavePath := A_ScriptDir "\" IfNotExist, %SavePath% FileCreateDir, %SavePath% pToken := Gdip_Startup() pBitmap := Gdip_CreateBitmapFromClipboard() Gdip_SaveBitmapToFile...
by FanaticGuru
15 Jun 2017, 13:03
Forum: Ask For Help
Topic: Webcam capture (fast)
Replies: 7
Views: 117

Re: Webcam capture (fast)

You might be able to incorporate the GDI+ library to saving an image from clipboard to a file instead of using IrfanView. (GDI+ library is available on the forums somewhere, though I have never used it.) This might be useful. This is a function to save a window image to a file using GDI+: Win2File(...
by FanaticGuru
13 Jun 2017, 17:24
Forum: Ask For Help
Topic: Extracting words and symbols with regex
Replies: 5
Views: 104

Re: Extracting words and symbols with regex

If I am understanding correct, what you want is very simple: Clipboard := "#he sale* man[] clogs(12g) 'across 6 parad*! 7he +ompatibl1 1elov3d apologi9es next to ? h=dden @reck. _hen can the *2384 torture 3 se32546g drago4? The conflic+* $345 =@+ #678 outside * 123olic ^@cre7p. The ?343* 77% in...
by FanaticGuru
13 Jun 2017, 14:54
Forum: Ask For Help
Topic: Need some help writing a Find & Replace script
Replies: 6
Views: 111

Re: Need some help writing a Find & Replace script

;~ Get the Information from a Haystack and a Needle File ;~ if the file paths do not change they could be hardcopied without use FileSelectFile ;~ "Loop, Files, FilePattern" could be used to have it Loop through all template XML based on a folder or pattern FileSelectFile, Haystack_Path,,...
by FanaticGuru
13 Jun 2017, 12:53
Forum: Ask For Help
Topic: Slow Text in MS Outlook Topic is solved
Replies: 9
Views: 105

Re: Slow Text in MS Outlook Topic is solved

Can we/nnobs find some/all of these here at the forum? Might come handy to absorb the concept of COM ! :) There are lots of examples of COM use with Outlook and Excel on the forums. Here are a few examples to get started: Loop through selected emails. F12:: Emails := ComObjActive("Outlook.Appl...
by FanaticGuru
12 Jun 2017, 19:41
Forum: Ask For Help
Topic: Need some help writing a Find & Replace script
Replies: 6
Views: 111

Re: Need some help writing a Find & Replace script

Couldn't the Find/Replace txt file just be one file with the Find and Replace combos on one line separated by a delimiter like tab: tree apple furniture table computer PC children Mary, Todd, and Suzy etc. That seems simpler. If I am understanding correctly what you want is very doable and probably ...
by FanaticGuru
12 Jun 2017, 19:25
Forum: Ask For Help
Topic: Slow Text in MS Outlook Topic is solved
Replies: 9
Views: 105

Re: Slow Text in MS Outlook Topic is solved

Check out if its still possible to open Outlook with a predefined template (that contains your text above). http://it.peikkoluola.net/2013/12/19/create-an-outlook-email-with-auto-filled-receiver-subject-and-body-from-the-command-line-bat/ Before I went the route of command line bat, I would just us...
by FanaticGuru
12 Jun 2017, 16:04
Forum: Ask For Help
Topic: Slow Text in MS Outlook Topic is solved
Replies: 9
Views: 105

Re: Slow Text in MS Outlook Topic is solved

Is there a workaround or a fix for the slow text when using hotstrings? Any help GREATLY appreciated. Have a good one. You might try putting the text on the clipboard and then pasting it. Clipboard := "Thanks, " Name# ".`n`nYour price has been updated, and " Vendor# " will ...
by FanaticGuru
08 Jun 2017, 18:40
Forum: Ask For Help
Topic: variable transfer betwen ahk programs
Replies: 1
Views: 60

Re: variable transfer betwen ahk programs

Below is a link to a library of functions called GuiVar that can do what you.
https://autohotkey.com/boards/viewtopic.php?t=3275

FG
by FanaticGuru
06 Jun 2017, 11:54
Forum: Ask For Help
Topic: Help parsing text
Replies: 4
Views: 114

Re: Help parsing text

The Needle has not been tested much but here is the basic concept of looping from Needle to Needle in a Haystack. Haystack := "Text text text Version 123, text text text Version ABC" Needle := "U)Version\s([^,]*)(,|$)" X:=1 while (X := RegExMatch(Haystack, Needle, M, X+StrLen(M))...
by FanaticGuru
05 Jun 2017, 19:36
Forum: Ask For Help
Topic: AHK'n image from file into Illustrator
Replies: 3
Views: 97

Re: AHK'n image from file into Illustrator

I had a whole post written but think I made my question too complicated so here its simplified. Is there a way to use a simple sequence to insert one of hundreds of image files into an Illustrator document? I work in apparel and I've got dozens of garment styles, most in dozens of colors, so being ...
by FanaticGuru
02 Jun 2017, 12:40
Forum: Ask For Help
Topic: More efficient code
Replies: 4
Views: 129

Re: More efficient code

You probably need to enclose both the "key" and "value" in the array in quotes if complex. Applications := {"APP1-NAME-Production-Env-Ver1": "APP1 - Person action - ", "APP2-NAME-Production-Env-Ver1": "APP1 - Person action - ", "APP2-N...

Go to advanced search