Search found 709 matches

by FanaticGuru
Today, 13:39
Forum: Ask For Help
Topic: How to combine multiple scripts in one?
Replies: 9
Views: 7135

Re: How to combine multiple scripts in one?

From the sounds of it in this thread, there is no way to have a "global" variable that can be used in one script that contains multiple hotkeys. I use one script to run a bunch of different hotkeys that are located in the startup folder, and one of the things that I was hoping to do is as...
by FanaticGuru
Today, 13:20
Forum: Ask For Help
Topic: excel open specific sheet
Replies: 3
Views: 45

Re: excel open specific sheet

pathy := A_WorkingDir . "\new.xlsx" xls := ComObjCreate("Excel.Application") xls.visible := true xls.workbooks.open(pathy) xls.sheets("JFK").select ; selects the sheet return I use Activate instead of Select but I don't know if there is a great deal of difference. xlAp...
by FanaticGuru
13 Oct 2017, 13:58
Forum: Ask For Help
Topic: Running an Excel macro
Replies: 3
Views: 72

Re: Running an Excel macro

This is not necessarily a new problem, but I am struggling with it. I am trying to open an Excel workbook, run a macro, then have the ahk script continue to run. I can get the file to open and the macro to run, but it goes south after that. Excel throws a hissy fit because it sees any ahk code afte...
by FanaticGuru
12 Oct 2017, 15:19
Forum: Ask For Help
Topic: Outlook COM: Setting account to send from
Replies: 29
Views: 657

Re: Outlook COM: Setting account to send from

FanaticGuru, this is awesome! How did you find these events, and how can I find more of them? Since Outlook 2016 disabled launching a script/exe internally via a mail "Rule", I'm looking for a way to trigger a script (via ahk) by monitoring Outlook events. For instance, to trigger a scrip...
by FanaticGuru
12 Oct 2017, 14:31
Forum: Ask For Help
Topic: Remove a mail into "mailto field"
Replies: 6
Views: 106

Re: Remove a mail into "mailto field"

Hello! It open a new ReplyAll window as you said and the MsgBox display as expected. But that's it, the email I wrote instead of "remove@example.com" stayed in the "To" section. It could be the RegExReplace is not being used properly to remove the email address. Also an email ad...
by FanaticGuru
10 Oct 2017, 15:04
Forum: Ask For Help
Topic: Remove a mail into "mailto field"
Replies: 6
Views: 106

Re: Remove a mail into "mailto field"

I did that but it doesn't remove the mail. :( I can tell you that the code works for me. Without additional information I cannot tell you why it does not work for you. Does the reply email display? Does the MsgBox display the 'To' and 'CC' that you would expect? The more you tell people the more li...
by FanaticGuru
09 Oct 2017, 19:19
Forum: Ask For Help
Topic: Translation of VBA to split names into title, first name, middle name, last name, suffix? Alt: Insert signed VBA?
Replies: 8
Views: 124

Re: Translation of VBA to split names into title, first name, middle name, last name, suffix? Alt: Insert signed VBA?

Looking into both of those... Will keep posted. The registry values are wrong from the first link (for my version of Excel 3 is digitally signed, and 2 is with notifications), but a registry edit followed by a vba import, then insert formula, then copy and paste-values the columns, then registry ed...
by FanaticGuru
06 Oct 2017, 15:10
Forum: Ask For Help
Topic: PowerPoint COM Save PPT as PDF Topic is solved
Replies: 3
Views: 52

Re: PowerPoint COM Save PPT as PDF Topic is solved

pptPresentation.ExportAsFixedFormat("C:\users\chris.miller1\desktop\test.pdf", ppFixedFormatTypePDF, ppFixedFormatIntentScreen, msoTrue, ppPrintHandoutHorizontalFirst, ppPrintOutputSlides, msoFalse, objPrintOptions.Ranges(1), ppPrintAll, "Slideshow Name", False, False, False, Fa...
by FanaticGuru
06 Oct 2017, 13:28
Forum: Ask For Help
Topic: Remove a mail into "mailto field"
Replies: 6
Views: 106

Re: Remove a mail into "mailto field"

Here is an example of how to do somethings with Outlook through COM with AHK: F12:: olMailItem := ComObjActive("Outlook.Application").ActiveWindow.CurrentItem olReplyAllItem := olMailItem.ReplyAll olReplyAllItem.Display MsgBox % "To: " olReplyAllItem.To "`n" "CC: &...
by FanaticGuru
05 Oct 2017, 16:20
Forum: Ask For Help
Topic: How to remove blank cells from the specific column in MS Excel?
Replies: 24
Views: 1009

Re: How to remove blank cells from the specific column in MS Excel?

I'm getting this error message now when I run the script- Error: 0x800A03EC - Source: (null) Description: (null) HelpFile: (null) HelpContext: 0 Specifically: Range Then it points to the line for Cell in Xl.Range("A1:A100").Cells This error can be caused for various reason that has to do ...
by FanaticGuru
05 Oct 2017, 15:26
Forum: Ask For Help
Topic: sending a sequence of keystrokes in MS Word Topic is solved
Replies: 6
Views: 66

Re: sending a sequence of keystrokes in MS Word Topic is solved

I am so new that never Heard about the COM. Sorry for hijacking the thread. Regarding the Word: I am not sure it does buffer? We have "templates" in Word that we open where we have to change some things. To "jump" between where we need to change we press F11. And sometimes we ne...
by FanaticGuru
05 Oct 2017, 00:42
Forum: Ask For Help
Topic: sending a sequence of keystrokes in MS Word Topic is solved
Replies: 6
Views: 66

Re: sending a sequence of keystrokes in MS Word Topic is solved

You have to take into consideration the speed of the computer as well thus a break between them will ensure it will work. My computer can't handle it without sleep. It switches slower and thus sends everything to fast. That is not my experience at all with MS Word. SendMode Input ; Recommended for ...
by FanaticGuru
04 Oct 2017, 19:13
Forum: Ask For Help
Topic: sending a sequence of keystrokes in MS Word Topic is solved
Replies: 6
Views: 66

Re: sending a sequence of keystrokes in MS Word Topic is solved

However, that may move too fast for Word to keep up with. You may need to either break the Send command into individual lines, one key per line, and put Sleep commands between the Send commands, or you can use SetKeyDelay . On the other hand, many times, this time included MS Word can handle the ke...
by FanaticGuru
04 Oct 2017, 18:39
Forum: Ask For Help
Topic: How to remove blank cells from the specific column in MS Excel?
Replies: 24
Views: 1009

Re: How to remove blank cells from the specific column in MS Excel?

This discussion seems like a good starting point. I'm a newbie on AHK so pardon my ignorance here. With this script will AHK then have each cell from the array stored as a separate variable? Basically, I am trying to automate the process of taking a list of names from Excel in a single column and t...
by FanaticGuru
02 Oct 2017, 02:43
Forum: Ask For Help
Topic: How to make Cross-Hair overlay click-through?
Replies: 8
Views: 138

Re: How to make Cross-Hair overlay click-through?

Here is a link to a version that seems to work well.
https://autohotkey.com/boards/viewtopic.php?t=29256

Shows how to make the png fade in and out.

FG
by FanaticGuru
01 Oct 2017, 19:41
Forum: Ask For Help
Topic: Imagesearch a non-rectangular object
Replies: 4
Views: 68

Re: Imagesearch a non-rectangular object

Folks, is it possible to search (via imagesearch or by another method) for an object that is not rectangular? The screen is full of tiles of different colors. On each tile, there is an icon. There are a variety of six icons of different, irregular shapes and about six colors also, and I would like ...
by FanaticGuru
01 Oct 2017, 16:37
Forum: Ask For Help
Topic: Ignore some numbers when sorting numerically Topic is solved
Replies: 9
Views: 190

Re: Ignore some numbers when sorting numerically Topic is solved

Thank you all for helping out and explaining your suggestions instead of just proposing them! For those who suggested a straight forward "sort string" solution, this works but becomes a problem when the tab delimited zeros change to other values, this would then mess up the sorting unless...
by FanaticGuru
30 Sep 2017, 21:43
Forum: Ask For Help
Topic: Ignore some numbers when sorting numerically Topic is solved
Replies: 9
Views: 190

Re: Ignore some numbers when sorting numerically Topic is solved

Hi I need to re order a variable which contains a list of numbers which look something like this: 101-047-050 0 0 0 0 0 101-047-060 0 0 0 0 0 101-012-020 0 0 0 0 0 101-047-010 0 0 0 0 0 101-012-030 0 0 0 0 0 where the 000-000-000 is an ID and the the rest are tab delimited values which belong to th...
by FanaticGuru
30 Sep 2017, 01:55
Forum: Ask For Help
Topic: Script for getting properties of PDF and saving to excel
Replies: 14
Views: 691

Re: Script for getting properties of PDF and saving to excel

I'm trying to detect bad pdfs using the meta data from xpdfinfo and this script, if it can output that meta data, would be the best thing I've found so far. I have full Acrobat, but xpdfinfo is doing a better job at detecting invalid pdfs than Acrobat is. Most of my pdfs were scanned in on other so...
by FanaticGuru
29 Sep 2017, 17:31
Forum: Ask For Help
Topic: OSD in fullscreen games?
Replies: 4
Views: 75

Re: OSD in fullscreen games?

Hello. Is it possible for AHK to bring up an OSD panel with some text in it, while in-game? I am asking because I have dozens of custom hotkeys spread across several games, and I need a way to have a list of them to pop up while playing the games and I cant remember them. GUIs unfortunately dont ap...

Go to advanced search