Hi guis, thank you soooo much for your help! @swagfag: especially to you. Your example using sort was incredible. Struggled a little bit to understand your special use but learned a lot(!) on how I can use it and how I can even create my own sorting function + regex! Thanks! @garry: Thank you for yo...

Hi everyone, I am trying to parse an xml file to csv. I then want to sort this csv file by one of the columns and display that in notepad. The xml file looks like this: <?xml version="1.0" encoding="utf-16"?> <Searches> <Search Name="Billy, Jean (#1234)" Id="15" Date="31.07.2018 11:17:00" SearchStr...

Hi everyone, I posted a new topic becaus my old topic seems to have run dry ( https://autohotkey.com/boards/viewtopic.php?p=183033#p183033 , post from 27th october 017)... I have a freshly generated workbook (not saved, it is generated by another programm which gives me a workbook with data I search...

Does any one have a hint for me to get the recorded macro running? Viewing the recorded code in excel's vba editor shows that the generated macro code is not quite what this macro does to the formatted cells. My cells are not formatted "d/m/yy h:mm;@", the date and time format I get (and want) is "5...

@jaaksbus Part of the problem I see with your code is I would not expect oExcel.Run("Macro9") to cause AHK to wait for "Macro9" to finish. AHK will send that command to Excel and then immediately continue on doing whatever is next in the AHK script. If the Excel macro takes very long to finish, you ...

Hi FanaticGuru, thanks for your hint. It worked right away but Excel now seems to be the problem: I changed my ahk code to the following: #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. ; #Warn ; Enable warnings to assist with detecting common errors. SetWorki...

It is stil not working. By now I have stored my macro in my personal workbook (PERSONAL.XLSB). The workflow should be as follows: ahk lets app A call excel to export its data into a new excel sheet ahk waits for the yet unnamed excel window to appear if the new excel sheet is opened ahk calls the ma...

@nnnik: Followed your hint. I checked both machines, only showed two different ahk versions. So I did a search on autohotkey*.exe and found the old exe which I then remembered that it was the first version I placed in another directory after playing with ahk for about an hour. I deleted it an everyt...

@nnnik: This morning I did a fresh install of ahk 1.1.26.01. Then I ran the following #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. ; #Warn ; Enable warnings to assist with detecting common errors. SendMode Input ; Recommended for new scripts due to its supe...

@nnnik: I installed AHK using the installer version, just a standard install...same install procedure on both machines, but on the one that is administrated by an admin ahk studio throws this error message. AHK studio is started from my user directory. Scite4AutoHotkey runs fine on both machines, bo...

Just found this :https://autohotkey.com/boards/viewtopic ... xcel+macro

At least now I know hot to start my personal workbook containing my macros. So until I get to know how to run an external .bas file on excel I will try to use my personal workbook. I'll keep working on it ;o)

Hi, I am having nearly the same problem. I have an app that gives me some data as an excel sheet. I have to change some cell formats and stuff to manipulate the format of the cells. Then I write this excel sheet into a uft8.txt file, which separates the cells content by tabs. I then ahk reads this u...

Hi everyone, this is my first post so forgive me if I made some faults -- still learning, also ahk, total beginner, but very qurious ;) I am having troubel to get ahk studio to run. Downloaded the latest version 2 days ago, running AHK 1.1.25, and when I start the ahk file I get the following error ...