Search found 844 matches

by FanaticGuru
Yesterday, 19:06
Forum: Ask For Help
Topic: Assign string a variable
Replies: 3
Views: 41

Re: Assign string a variable

Hi, Here's a way to achieve this using SubStr , InStr and StrLen functions. haystack := "AutoHotkey aka AHK. description: Automation scripting language." needle := "description: " needleLength := StrLen(needle) position := InStr(haystack, "description: ") cuantosCaract...
by FanaticGuru
Yesterday, 18:44
Forum: Ask For Help
Topic: AHK Auto Formatter?
Replies: 6
Views: 1121

Re: AHK Auto Formatter?

Hi, if you still have it, could you please reupload it somewhere? Here it is but I don't believe it works with the current version of AutoHotkey. ;Change indentation and case of commands according to syntax ;by toralf & hajos ;requires AHK 1.0.44.09 ;www.autohotkey.com/forum/topic7810.html Vers...
by FanaticGuru
Yesterday, 13:28
Forum: Ask For Help
Topic: Copy cell values between Excel files without keystrokes
Replies: 5
Views: 132

Re: Copy cell values between Excel files without keystrokes

Is there a way to access the xlsx file in the Folder without setting the \Folder\Temp.xlsx path by looking for just the file type? For example like \Folder\.xlsx. Here is an example of how to loop through all of a certain type files in a folder. FileFrom_Pattern := A_Desktop "\Test\*.xlsx"...
by FanaticGuru
22 Jan 2018, 15:51
Forum: Ask For Help
Topic: Copy cell values between Excel files without keystrokes
Replies: 5
Views: 132

Re: Copy cell values between Excel files without keystrokes

Here is a start: ; Open new instance of Excel and show it xlApp := ComObjCreate("Excel.Application") xlApp.Visible := true ; Define the paths to two Excel files (used A_Desktop to point to the files on my computer but could use absolute paths) FileFrom_Path := A_Desktop "\Test\Test1.x...
by FanaticGuru
19 Jan 2018, 17:32
Forum: Ask For Help
Topic: Users Posts vanishing? Topic is solved
Replies: 10
Views: 190

Re: Users Posts vanishing? Topic is solved

I only know those cases. A thread ... 1) has been moved bc it has been posted at the wrong section. 2) has been removed bc its content has violated any forum/common rules. 3) has been removed bc it has been posted multiple times. 4) a post has been re/moved bc of 1), 2) or 3) None of the above opti...
by FanaticGuru
16 Jan 2018, 01:50
Forum: Ask For Help
Topic: Email Topic is solved
Replies: 8
Views: 175

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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...

Go to advanced search