Search found 211 matches

by awel20
10 Sep 2020, 09:19
Forum: Editors
Topic: scite4autohotkey color
Replies: 2
Views: 74

Re: scite4autohotkey color

I think this is the line that changes that setting: caret.line.back.alpha=0 You can add the above line to the style file for a particular theme, which will change the setting only for that theme. Or you can add that line to your user properties which will change the setting for all themes. For examp...
by awel20
04 Sep 2020, 11:33
Forum: Ask For Help
Topic: Issue with Excel Paste Options
Replies: 9
Views: 717

Re: Issue with Excel Paste Options

I also now noticed that I do NOT get the error if I switch to a different app between opening Excel and pressing the key, e.g.: I open Excel and create a new empty file I switch to e.g. Google Chrome I switch back to Excel I write something in a cell I copy and paste in another cell I press Ctrl-S,...
by awel20
21 Aug 2020, 16:55
Forum: Ask For Help
Topic: Converting Simple Excel VBA to AutoHotkey
Replies: 2
Views: 127

Re: Converting Simple Excel VBA to AutoHotkey

/* VBA Sub EndofCol() 'Selects all from activecell to last column of the complete data set. Dim myRow As Long Dim myCol As Long Dim RowNum As Long myRow = ActiveCell.Row myCol = ActiveCell.Column RowNum = ActiveCell.SpecialCells(xlLastCell).Row Range(Cells(myRow, myCol), Cells(RowNum, myCol)).Selec...
by awel20
07 Aug 2020, 10:12
Forum: Scripts and Functions
Topic: Compass - Measure angles and scale distances with your mouse
Replies: 37
Views: 16617

Re: Compass - Measure angles and scale distances with your mouse

There might be a memory or GDI object leak, it crashes for me after running for a little while. I think you are right but I don't see the cause. I might mess around with drawing the dimension inline with the actual line via gdip and ditch the tooltip altogether. Also I added crosshairs and separate...
by awel20
06 Aug 2020, 14:16
Forum: Scripts and Functions
Topic: Compass - Measure angles and scale distances with your mouse
Replies: 37
Views: 16617

Re: Compass - Measure angles and scale distances with your mouse

nice update, small bug: when snap is on, the second line created moves the endpoint of the previous line to its unsnapped position Thanks for pointing that out. Actually, I saw that behavior once during my brief testing but I didn't see it again so I forgot about it. It should be fixed now (I edite...
by awel20
05 Aug 2020, 16:23
Forum: Scripts and Functions
Topic: Compass - Measure angles and scale distances with your mouse
Replies: 37
Views: 16617

Re: Compass - Measure angles and scale distances with your mouse

Edit : I've changed this post to include the changes from later in this thread. This should make it easier for people to just copy and paste the following script for a simple working example. I added the crosshairs created by @gwarble and also fixed the memory leak he mentioned later in this thread...
by awel20
04 Aug 2020, 10:59
Forum: Ask For Help
Topic: How to copy multiple folders using FileCopyDir? Topic is solved
Replies: 6
Views: 2459

Re: How to copy multiple folders using FileCopyDir? Topic is solved

In your script you are hard coding each individual folder in the source and destination. for example C:\Folder\ScriptDirectory\SourceFolder\2502 This part is hard coded in my script: :\Folder\ScriptDirectory\SourceFolder\ and this part is read from rd.txt: 2502 In my script ideally I want the scrip...
by awel20
04 Aug 2020, 10:32
Forum: Ask For Help
Topic: Making a ruler and other measuring device. Topic is solved
Replies: 13
Views: 5180

Re: Making a ruler and other measuring device. Topic is solved

That description sounds kind of similar to another existing script that I know about. I modified the hotkey from the exiting script so that it records the last 3 measurements and copies them to the clipboard when done. (You will also need to copy and paste the existing script I mentioned which can b...
by awel20
31 Jul 2020, 09:31
Forum: Ask For Help
Topic: How to copy multiple folders using FileCopyDir? Topic is solved
Replies: 6
Views: 2459

Re: How to copy multiple folders using FileCopyDir? Topic is solved

Change the folder paths back to the ones you originally had. I used the "\SourceFolder" and "\DestFolder" folders when I was testing the script myself. What do the message boxes say when you uncomment them? The first and second message boxes should contain the source folder number. ex: 2502 The last...
by awel20
31 Jul 2020, 09:22
Forum: Ask For Help
Topic: Automatic inclusion doesn't work with globals
Replies: 9
Views: 3820

Re: Automatic inclusion doesn't work with globals

This is one example of a static initializer. The two functions fn1() and fn2() call the function Init() at run time. The two functions share a reference to the same object which allows sharing of information between the functions. MsgBox % fn1() "`n" fn2() Init() { static ConfigArray := "" if !(Conf...
by awel20
30 Jul 2020, 12:50
Forum: Ask For Help
Topic: How to copy multiple folders using FileCopyDir? Topic is solved
Replies: 6
Views: 2459

Re: How to copy multiple folders using FileCopyDir? Topic is solved

Try this out. You can uncomment the message boxes to help with debugging. I assumed rd.txt was just something like this: 2502 2606 sourcepath := A_ScriptDir "\SourceFolder" ; sourcepath := "\\private\Users\JK\Documents\18-Customer complaint reports PDFs" destpath := A_ScriptDir "\DestFolder" ; "\\pr...
by awel20
30 Jul 2020, 11:02
Forum: Ask For Help
Topic: Need Help Getting Values from XML Text Topic is solved
Replies: 12
Views: 2675

Re: Need Help Getting Values from XML Text Topic is solved

How would I add title to each value? Like "ID:" Before AgencyId or "Number:" Before Incident Number You can add some text to this part: AllInfo .= "ID: " AgencyId1 "`n" AllInfo .= "Type Of Service Requested: " TypeOfServiceRequested1 AllInfo .= "ID#: " IncidentNumber1 "`n" AllInfo .= "Date and Time...
by awel20
30 Jul 2020, 10:57
Forum: Ask For Help
Topic: Need Help Getting Values from XML Text Topic is solved
Replies: 12
Views: 2675

Re: Need Help Getting Values from XML Text Topic is solved

XMLFilePath := A_ScriptDir "\FLOWMSP_202057dd_0757.xml" FileRead, XMLText, % XMLFilePath XMLDoc := ComObjCreate("MSXML2.DOMDocument.6.0") XMLDoc.async := false XMLDoc.loadXML(XMLText) XPaths := [["ID", "/CadData/EmsIncidentCollection/EmsIncident/AgencyId"] , ["Number", "/CadData/EmsIncidentCollecti...
by awel20
30 Jul 2020, 10:37
Forum: Ask For Help
Topic: How to check if a pointer points to an IStream interface? Topic is solved
Replies: 2
Views: 842

Re: How to check if a pointer points to an IStream interface? Topic is solved

I think you can use ComObjQuery to check if an interface is supported. This is V1.1 code, so I used the BufferAlloc function from here: https://www.autohotkey.com/boards/viewtopic.php?style=17&t=65248 Note that instead of CLSID (V2) this uses CLSID.ptr (V1.1 function). IID_IStream := "{0000000C-0000...
by awel20
29 Jul 2020, 13:51
Forum: Ask For Help
Topic: Need Help Getting Values from XML Text Topic is solved
Replies: 12
Views: 2675

Re: Need Help Getting Values from XML Text Topic is solved

The following example is based on the example from the COM Object Reference topic found here: https://www.autohotkey.com/boards/viewtopic.php?f=6&t=77#p488 It shows how to load the XML from text and read a value. ; COM Ojbect Reference: https://www.autohotkey.com/boards/viewtopic.php?f=6&t=77#p488 X...
by awel20
29 Jun 2020, 14:06
Forum: Ask For Help
Topic: DllCall w/o function name Topic is solved
Replies: 3
Views: 985

Re: DllCall w/o function name Topic is solved

It's a memory address for the function to call. [v1.0.46.08+]: This parameter may also consist solely of an integer, which is interpreted as the address of the function to call. Sources of such addresses include COM and RegisterCallback(). https://www.autohotkey.com/docs/commands/DllCall.htm There i...
by awel20
26 Jun 2020, 13:05
Forum: Ask For Help
Topic: (COM) AHK and Excel - How to filter a column using multiple criteria? Topic is solved
Replies: 2
Views: 1000

Re: (COM) AHK and Excel - How to filter a column using multiple criteria? Topic is solved

xlFilterValues := 7 Criteria1 := ComObjArray(0xC, 4) Criteria1[0] := "120" Criteria1[1] := "122" Criteria1[2] := "123" Criteria1[3] := "128" xlApp := ComObjActive("Excel.Application") xlApp.Worksheets("Sheet1").ListObjects("Table1").Range.AutoFilter(1, Criteria1, xlFilterValues) xlApp := "" xlFilte...

Go to advanced search