Search found 839 matches

by FanaticGuru
16 Jan 2018, 01:50
Forum: Ask For Help
Topic: Email Topic is solved
Replies: 8
Views: 153

Re: Email Topic is solved

Hi guys, I've seen this post showing how to get the e-mail date and time from Outlook. https://autohotkey.com/board/topic/115395-getting-e-mail-date-and-time-from-outlook/ I am trying to add it to the previous script (which FanaticGuru helped me come with.), so I can get the time & the date of ...
by FanaticGuru
15 Jan 2018, 15:38
Forum: Ask For Help
Topic: Email Topic is solved
Replies: 8
Views: 153

Re: Email Topic is solved

I was wondering how I can read the 'unread' emails (including the subject and the body) by using AHK. I've found below VBA script, but I still have the issue to embed it with AHK. This is fairly simple if you know the structure of the object. olApp := ComObjActive("Outlook.Application") ;...
by FanaticGuru
12 Jan 2018, 00:55
Forum: Ask For Help
Topic: Email Topic is solved
Replies: 8
Views: 153

Re: Email Topic is solved

A more robust example: Account := "Me@FG.com" Recipients := ["Them <Somebody@Somewhere.com>", "We <WeeWee@Piggy.com>"] RecipientsCC := ["Us <Us@Ussy.com>", "Those <ThoseGuys@Those.com>"] RecipientsBCC := ["Sneaky <Sneak@Sneak.com>", "V...
by FanaticGuru
12 Jan 2018, 00:23
Forum: Ask For Help
Topic: Email Topic is solved
Replies: 8
Views: 153

Re: Email Topic is solved

Hey guys, I am trying to find out how I can send the email by using AHK. I am able to create the VBA in excel, and then send the email. (Please refer to below script) Do you know how I can embed this script into AHK, so I could use AHK to send emails? /*VBA - Send emails*/ Dim objOutlook As Object ...
by FanaticGuru
11 Jan 2018, 17:11
Forum: Ask For Help
Topic: Copying huge .txt files content to Excel sheets
Replies: 10
Views: 153

Re: Copying huge .txt files content to Excel sheets

Here is all COM code using Odlanir's file looping framework: xlApp := ComObjCreate("Excel.Application") xlApp.Visible := true xlWB := xlApp.Workbooks.open(" C:\Users\user\Dropbox\Profissional\Project\Sheets\Sheet.xlsx") xlWS := xlWB.Sheets("Data") xlApp.ScreenUpdating :...
by FanaticGuru
11 Jan 2018, 16:59
Forum: Ask For Help
Topic: Copying huge .txt files content to Excel sheets
Replies: 10
Views: 153

Re: Copying huge .txt files content to Excel sheets

@ FanaticGuru. There's a HUGE difference. My code paste the clipboard contents starting fom row 1 ( column incremented by loop ) and populate as many rows as the input file rows. So every iteration should populate a single column with the file records, line by line till column 32. Your code try to ...
by FanaticGuru
11 Jan 2018, 03:26
Forum: Ask For Help
Topic: Copying huge .txt files content to Excel sheets
Replies: 10
Views: 153

Re: Copying huge .txt files content to Excel sheets

Try this. Tested wit 65k lines. XL := ComObjCreate("Excel.Application") XL.Visible := true WB := XL.Workbooks.open(" C:\Users\user\Dropbox\Profissional\Project\Sheets\Sheet.xlsx") WS := WB.Sheets("Data") loop, 32 { FileRead, varx, % "C:\Project\" format("...
by FanaticGuru
10 Jan 2018, 02:34
Forum: Ask For Help
Topic: Excel: copy and paste without using the clipboard
Replies: 1
Views: 43

Re: Excel: copy and paste without using the clipboard

- Is there a way in Excel to copy and paste, without using the clipboard? - I've made an attempt at copying cells from one sheet to another, below, with/without using the clipboard. But it's possible that the script could be improved. Not that I have discovered. You are only transferring 3 properti...
by FanaticGuru
09 Jan 2018, 19:51
Forum: Ask For Help
Topic: New to data parsing of text file using arrays... needing direction
Replies: 9
Views: 106

Re: New to data parsing of text file using arrays... needing direction

Question: Will this produce the largest marker time, or the largest region between markers? ; Find Highest Length for index, Marker in Markers if (Marker.Length > Hi) Hi := Marker.Length, HiX := index This calculates and stores the change in each Markers' Time which is the Length of that Marker: ; ...
by FanaticGuru
09 Jan 2018, 16:37
Forum: Ask For Help
Topic: New to data parsing of text file using arrays... needing direction
Replies: 9
Views: 106

Re: New to data parsing of text file using arrays... needing direction

WOW!!! Lots of goodies to look at now! Thanks! Is there a difference between these lines (1.2, 2.2 and 3.2 below) as it applies to performing mathematical manipulations on the array values?? I'm needing to calculate the time differences between each of the 'markers', and identify which one is the l...
by FanaticGuru
09 Jan 2018, 14:17
Forum: Ask For Help
Topic: New to data parsing of text file using arrays... needing direction
Replies: 9
Views: 106

Re: New to data parsing of text file using arrays... needing direction

Here is an example of using RegEx to parse a string. Data = ( FLOATPOS 0 0 0 0 FXID {BB787D93-DE7A-4536-ACEA-DD4A33747ECB} WAK 0 > <MASTERPLAYSPEEDENV ACT 0 -1 VIS 0 1 1 LANEHEIGHT 0 0 ARM 0 DEFSHAPE 0 -1 -1 > <TEMPOENVEX ACT 0 -1 VIS 1 0 1 LANEHEIGHT 0 0 ARM 0 DEFSHAPE 1 -1 -1 > MARKER 1 538.024555...
by FanaticGuru
03 Jan 2018, 19:23
Forum: Ask For Help
Topic: Need help about Associative Arrays
Replies: 9
Views: 164

Re: Need help about Associative Arrays

I have some data is like this {"name":"Baal","age":"50"} ,this data in a Variables named DATA. Since your data is in proper JSON format, you could using any JSON parsing code to convert such string to an AHK object. One of the approaches is using JScript for ...
by FanaticGuru
03 Jan 2018, 18:02
Forum: Ask For Help
Topic: Single variable function returning variable name and value
Replies: 5
Views: 75

Re: Single variable function returning variable name and value

Maybe I am missing something but this seems pretty simply if you are willing to send the variable name as a literal. firstVariable := 34 nextVariable := 42 MsgBox % MySpecialFunction("firstVariable") ; returns "firstVariable : 34" MsgBox % MySpecialFunction("nextVariable&quo...
by FanaticGuru
03 Jan 2018, 17:37
Forum: Ask For Help
Topic: Excel reading and converting Topic is solved
Replies: 7
Views: 150

Re: Excel reading and converting Topic is solved

xlApp := ComObjActive("Excel.Application") ; Get Data from Excel and Put in Array "Processes" Cell_Base := xlApp.Range("A3") Row := Cell_Base.Row Col := Cell_Base.Column oGroups := {}, xProc := 0 for Sheet in xlApp.Sheets { oProcesses := {} while !((sProcess := Sheet.C...
by FanaticGuru
02 Jan 2018, 14:40
Forum: Ask For Help
Topic: Excel reading and converting Topic is solved
Replies: 7
Views: 150

Re: Excel reading and converting Topic is solved

I made a loop throught the sheets, because there can be multiple sheets. And each sheet means a different group. I captured the groups in Array, but I met a problem when I want to add it to final Array. Just another layer to the onion. xlApp := ComObjActive("Excel.Application") ; Get Data...
by FanaticGuru
29 Dec 2017, 18:05
Forum: Ask For Help
Topic: Excel reading and converting Topic is solved
Replies: 7
Views: 150

Re: Excel reading and converting Topic is solved

Maybe the code below will provide some insight. The first section gets the information from Excel and structures it into an array. The next section iterates through that array to create a display string for all the information in a generic way. The next section iterates through that array to create ...
by FanaticGuru
29 Dec 2017, 16:30
Forum: Ask For Help
Topic: Renaming Excel Worksheet Tabs
Replies: 5
Views: 121

Re: Embedding variables in expression format

Loop, 3 { oWorkbook.Worksheets("Template - Mason").Copy(oWorkbook.Worksheets("Sheet3")) ; copy Sheet1 and place it before Sheet2 oWorkbook.Worksheets("Template - Mason (2)").activate oWorkbook.ActiveSheet.Name := "Mason " . Datea_index } This code creates &qu...
by FanaticGuru
28 Dec 2017, 21:34
Forum: Scripts and Functions
Topic: Hotkey Help - Display Active AHK Hotkeys and Hotstrings
Replies: 31
Views: 11722

Re: Hotkey Help - Display Active AHK Hotkeys and Hotstrings

As a followup, so far as the can't create control, I run the script, what I assume is happening is it is running and gathering from the scripts running and when it hits the upper level of whatever is stopping it, the size, it pops up with the error can't create control, right before the time when n...
by FanaticGuru
28 Dec 2017, 14:06
Forum: Ask For Help
Topic: How to Check faster for more then 1500+ IfWinNotExist Topic is solved
Replies: 14
Views: 223

Re: How to Check faster for more then 1500+ IfWinNotExist Topic is solved

RegEx was made for pretty much exactly this type thing. SetTitleMatchMode, RegEx IfWinNotExist, ^30\d{4}\.ahk { MsgBox 30####.ahk file NOT open return } MsgBox 30####.ahk file IS open This will look for any window with a title that starts with 30 then 4 digits and ending in .ahk then do or not do wh...
by FanaticGuru
28 Dec 2017, 13:01
Forum: Ask For Help
Topic: Outlook 2010 Open Attachment file to view
Replies: 4
Views: 55

Re: Outlook 2010 Open Attachment file to view

You might find the below code useful for opening email attachments. F12:: Emails := ComObjActive("Outlook.Application").ActiveExplorer.Selection for Email in Emails for Attachment in Email.Attachments if !(Attachment.FileName ~= "^image\d+") ; exlude image files often created by ...

Go to advanced search