Search found 714 matches

by FanaticGuru
Yesterday, 17:35
Forum: Ask For Help
Topic: Outlook COM: Setting account to send from
Replies: 33
Views: 713

Re: Outlook COM: Setting account to send from

global olApp := ComObjActive("Outlook.Application") ComObjConnect(olApp, "EventApp_") EventApp_NewMailEx(IDs) { MsgBox You have a new e-mail } No need for an If . Events by their nature only trigger "if" the event occurs. FG Thanks for your help. This event (getting a ...
by FanaticGuru
Yesterday, 13:50
Forum: Ask For Help
Topic: Outlook COM: Setting account to send from
Replies: 33
Views: 713

Re: Outlook COM: Setting account to send from

How should I format this? olApp := ComObjActive("Outlook.Application") ComObjConnect(olApp, "EventApp_") if EventApp_NewMailEx() { MsgBox You have a new e-mail } Thanks! global olApp := ComObjActive("Outlook.Application") ComObjConnect(olApp, "EventApp_") Eve...
by FanaticGuru
Yesterday, 13:42
Forum: Ask For Help
Topic: rename specific excel sheet
Replies: 1
Views: 20

Re: rename specific excel sheet

this works: #SingleInstance, Force ObjExcel := ComObjCreate("Excel.Application") ObjExcel.Visible := True ObjWorkbook := ObjExcel.Workbooks.Add() return F1:: ObjWorkbook.Worksheets.Add() ; Add Worksheet ObjWorkbook.Sheets("sheet1").Name := "Summary" return but i need c...
by FanaticGuru
Yesterday, 12:58
Forum: Ask For Help
Topic: Outlook - connect to the folder
Replies: 1
Views: 23

Re: Outlook - connect to the folder

I'm trying to connect to exact folder and Innboks in Outlook 2016 and read messages in this folder. So far I can read messages subject, body, sendername, but I struggle to connect to exact folder and innboks. Maybe someone can help me with this? Folder name is Favoritter , innboks called Innboks . ...
by FanaticGuru
18 Oct 2017, 15:30
Forum: Ask For Help
Topic: How to combine multiple scripts in one?
Replies: 11
Views: 7193

Re: How to combine multiple scripts in one?

I have a script that is compiled on the desktop with a shortcut in the startup folder. That script has quite a few different hotkeys in it that I like to all have available while I am working. I was hoping to assign a variable at the top of the script for my different passwords that I use for loggi...
by FanaticGuru
17 Oct 2017, 13:39
Forum: Ask For Help
Topic: How to combine multiple scripts in one?
Replies: 11
Views: 7193

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
17 Oct 2017, 13:20
Forum: Ask For Help
Topic: excel open specific sheet Topic is solved
Replies: 5
Views: 101

Re: excel open specific sheet Topic is solved

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: 75

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: 33
Views: 713

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: 112

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: 112

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: 53

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: 112

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: 1011

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: 68

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: 68

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: 68

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: 1011

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: 141

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

Go to advanced search