Search found 38 matches

by ShubhamM
03 Nov 2022, 19:52
Forum: Ask for Help (v1)
Topic: Outlook COM - Move Emails to Outlook Folders Topic is solved
Replies: 3
Views: 466

Re: Outlook COM - Move Emails to Outlook Folders Topic is solved

Actually, I happened to solve it using an over-arching for each loop on Selected_Emails, instead of "Loop, % Selected_Emails.count".

".Item(A_Index)" worked for saving files but not for this for some reason.

Thank you, nonetheless! Have a fantastic day!
by ShubhamM
01 Nov 2022, 11:59
Forum: Ask for Help (v1)
Topic: Outlook COM - Move Emails to Outlook Folders Topic is solved
Replies: 3
Views: 466

Outlook COM - Move Emails to Outlook Folders Topic is solved

Good Day, I'm trying to create a command that sends a collection of emails to their corresponding folders within Outlook. The 'Search_Test_String' is correctly found (as per the previous message boxes) but I receive an "Array index out of bounds." error on "Selected_Emails.Item(a_index).Move(main_fo...
by ShubhamM
30 May 2022, 17:27
Forum: Ask for Help (v1)
Topic: Select Outlook Folder via COM
Replies: 2
Views: 450

Select Outlook Folder via COM

Good Day, I am trying to open an Outlook folder based on a user input. I have the following code, which does display the folder but opens it in a new window. How do I adjust this such that a new window is not opened and just active explorer/selection changes to the folder I wish to have displayed? U...
by ShubhamM
16 Apr 2022, 11:54
Forum: Ask for Help (v1)
Topic: Creating Rules in Outlook
Replies: 2
Views: 338

Re: Creating Rules in Outlook

Ahh, yes, thank you for sharing that for others as I should have done so myself. I just need to figure out how to have the Rule.Conditions.Subject.Text property to accept strings. I believe the commented out variable Subject_Array creates an object containing an array and is not an array itself so I...
by ShubhamM
15 Apr 2022, 20:03
Forum: Ask for Help (v1)
Topic: Creating Rules in Outlook
Replies: 2
Views: 338

Creating Rules in Outlook

Good Day, I'm trying to create rules on Outlook based on text in the subject line of a received email, moving the email to a newly created folder. The rule is created and all aspects of the code below work with the exception of the Subject Condition, where I believe SubjectCondition.Text := "test" i...
by ShubhamM
14 Apr 2022, 09:44
Forum: Ask for Help (v1)
Topic: Export PDF to Excel Spreadsheet Topic is solved
Replies: 2
Views: 578

Re: Export PDF to Excel Spreadsheet Topic is solved

Awesome! Thanks so much and I think yours works but I actually just found this solution to this last night, searching Adobe Acrobat Javascript: PDF_Doc := ComObjCreate("AcroExch.PDDoc") PDF_Doc.Open(A_Desktop "\test.pdf") JSO := PDF_Doc.GetJSObject JSO.SaveAs(A_Desktop "\test.xlsx", "com.adobe.acrob...
by ShubhamM
13 Apr 2022, 18:07
Forum: Ask for Help (v1)
Topic: Export PDF to Excel Spreadsheet Topic is solved
Replies: 2
Views: 578

Export PDF to Excel Spreadsheet Topic is solved

Hi, I'm trying to convert a PDF into an excel spreadsheet. I do have a paid version of Adobe Acrobat so I can run commands like combining a PDF with COM. However, I do not know how to export the PDF into an excel spreadsheet with COM. I am able to do the conversion/export manually through the menu b...
by ShubhamM
04 Mar 2022, 14:44
Forum: Ask for Help (v1)
Topic: Reuse COM Object Topic is solved
Replies: 2
Views: 351

Re: Reuse COM Object Topic is solved

Thank you for the information provided. I apologize for the mistakes in my code; I have those all working on my end - I just copied, pasted, and edited incorrectly. I found a rather easy solution for my problem thanks to the information you provided, where I simply use an if-statement to check if th...
by ShubhamM
04 Mar 2022, 13:44
Forum: Ask for Help (v1)
Topic: Reuse COM Object Topic is solved
Replies: 2
Views: 351

Reuse COM Object Topic is solved

I have file (template) that I open, modify, and then save to its designated folder in one command via ComObjCreate. From here, I want to run other commands on the same file but after releasing it and by using ComObjActive. I'm able to restart my script or close the file and then reopen it to use Com...
by ShubhamM
01 Mar 2022, 19:17
Forum: Ask for Help (v1)
Topic: Highlight text in the middle of a line using COM in MS Word
Replies: 0
Views: 236

Highlight text in the middle of a line using COM in MS Word

Hi! I'm having trouble highlighting the middle of a line using COM on word. The following code is not working as it highlights the entire line instead of just the text in between: Word_App := ComObjCreate("Word.Application") Word_File := Word_App.Documents.Add() Word_App.Visible := 1 Word_App.Activa...
by ShubhamM
11 Jan 2019, 14:25
Forum: Ask for Help (v1)
Topic: Retrieve Process ID of a background application
Replies: 1
Views: 1068

Retrieve Process ID of a background application

Hi, I'm trying to obtain the unique process ID for a run of an excel application that's running in the background via COM so that I can kill/control that specific instance of excel (WinKill and IfWinActive, etc. don't respond to it as it doesn't show as a window). The following enables the excel fil...
by ShubhamM
30 Nov 2017, 18:09
Forum: Ask for Help (v1)
Topic: COM .SaveAs Overwrite file
Replies: 2
Views: 1457

Re: COM .SaveAs Overwrite file

You're the best, Gio! Thanks a lot for this! It works like a charm!
by ShubhamM
30 Nov 2017, 15:40
Forum: Ask for Help (v1)
Topic: COM .SaveAs Overwrite file
Replies: 2
Views: 1457

COM .SaveAs Overwrite file

Hey, everyone,

I want to use COM .SaveAs on a excel file but I do not want to be prompted on whether I want to save the file but I simply want it to overwrite the existing file. Is there any way to do this?

Thanks!
by ShubhamM
23 Nov 2017, 15:10
Forum: Ask for Help (v1)
Topic: Gui Caption in Windows 7
Replies: 1
Views: 446

Re: Gui Caption in Windows 7

Sorry, I forgot to mention that the following is at the top of the above code:

global Bool_Show_Caption := 0
by ShubhamM
23 Nov 2017, 15:09
Forum: Ask for Help (v1)
Topic: Gui Caption in Windows 7
Replies: 1
Views: 446

Gui Caption in Windows 7

Hello, I have the following code but I'm trying to re-add a Windows 7/8/10 caption into the program but it keeps giving me a Windows XP caption bar and also distorts the GUI with a little white bar added to the top and the left: Gosub, Start Return Start: Total_Width := 660 Gui, +LastFound Gui, Colo...
by ShubhamM
21 Nov 2017, 12:34
Forum: Ask for Help (v1)
Topic: Underline Text in GUI when pointer hovers over text
Replies: 5
Views: 1320

Re: Underline Text in GUI when pointer hovers over text

It's not an actual link that I wanted, but rather just the link select pointer. Nonetheless, this all helps a lot so I thank you guys a lot!! I thoroughly appreciate it!

Have an awesome day!
by ShubhamM
20 Nov 2017, 23:12
Forum: Ask for Help (v1)
Topic: Underline Text in GUI when pointer hovers over text
Replies: 5
Views: 1320

Re: Underline Text in GUI when pointer hovers over text

That's awesome! I'll give it a go. Do you happen to know how to change the pointer to the pointing hand that appears after you're hovering over a link?

Thanks a lot!
by ShubhamM
19 Nov 2017, 15:11
Forum: Ask for Help (v1)
Topic: Underline Text in GUI when pointer hovers over text
Replies: 5
Views: 1320

Underline Text in GUI when pointer hovers over text

Hello, Everyone,

I have a GUI with a bunch of text and I want to underline that text whenever my mouse pointer hovers over that text. Anyone know if this is possible and, if so, how to implement it?

Thanks for any help you can provide!
by ShubhamM
15 Nov 2017, 11:12
Forum: Ask for Help (v1)
Topic: COM Outlook Events
Replies: 26
Views: 5423

Re: COM Outlook Events

Thanks, man! This worked! I appreciate it so much! Just out of my curiosity, what do the "?" and ":" do in the message box or to the olRecip.Resolved variable? How do they work and how can they be used in the future? In addition, could you advise the same on ".Resolve". I thought it would be good to...
by ShubhamM
14 Nov 2017, 12:39
Forum: Ask for Help (v1)
Topic: COM Outlook Events
Replies: 26
Views: 5423

Re: COM Outlook Events

Hey there, FG,

No, this one did not work. If you have any other ideas off the top of your head, then I'd really appreciate them!! If not, don't stress it and I thank you, kindly, for all your help! You are too kind and brilliant!

Go to advanced search