AutoHotkey Community

FanaticGuru

I am working on cutting down a 6300 line monster into a smaller script. Is there any way to take Su + 0000 to become Su0000 and then to display the value of Su0000? "CHECKED" Didn't really look at your code to see if there is a better way but to answer your questions: day1:="Su" time1:=0000 Su0000:...

FanaticGuru

xlApp := ComObjActive("Excel.Application") ; Excel must be running FileTo_Path := A_Desktop "\Perm.xlsx" FileTo := xlApp.Workbooks.Open(FileTo_Path) FileFrom_Pattern := A_Desktop "\Test\*.xlsx" Loop, Files, % FileFrom_Pattern { FileFrom := xlApp.Workbooks.Open(A_LoopFileFullPath) if (A_Index = 1) {...

FanaticGuru

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: ") cuantosCaracteres := 10 substring := SubStr...

FanaticGuru

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

FanaticGuru

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" Loop, Fi...

FanaticGuru

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.xlsx" FileTo_Pat...

FanaticGuru

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

FanaticGuru

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

FanaticGuru

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") ; Use Creat...

FanaticGuru

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>", "Very Sneaky <VerySneak@Sneak.com>"] Subject := "Reports" Body = (J...

FanaticGuru

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

FanaticGuru

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 := false loop, 32 { FileRead, F...

FanaticGuru

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

FanaticGuru

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("{:04}",a_index) "\PARTEPL.LST" Clipboard := ...

FanaticGuru

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

FanaticGuru

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

FanaticGuru

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

FanaticGuru

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

FanaticGuru

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 this purpose. Full fledge JSON parsing i...

FanaticGuru

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") ; returns "nextVariable: 4...

Search found 1906 matches

Re: Concatenate strings to get variable names?

Re: Copy cell values between Excel files without keystrokes

Re: Assign string a variable

Re: AHK Auto Formatter?

Re: Copy cell values between Excel files without keystrokes

Re: Copy cell values between Excel files without keystrokes

Re: Users Posts vanishing? Topic is solved

Re: Email Topic is solved

Re: Email Topic is solved

Re: Email Topic is solved

Re: Email Topic is solved

Re: Copying huge .txt files content to Excel sheets

Re: Copying huge .txt files content to Excel sheets

Re: Copying huge .txt files content to Excel sheets

Re: Excel: copy and paste without using the clipboard

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

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

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

Re: Need help about Associative Arrays

Re: Single variable function returning variable name and value