Search found 13 matches

by Geramont
07 Nov 2018, 11:17
Forum: Ask For Help
Topic: parse a text file to csv and then sort by column Topic is solved
Replies: 9
Views: 921

Re: parse a text file to csv and then sort by column Topic is solved

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...
by Geramont
03 Nov 2018, 11:24
Forum: Ask For Help
Topic: parse a text file to csv and then sort by column Topic is solved
Replies: 9
Views: 921

parse a text file to csv and then sort by column Topic is solved

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...
by Geramont
03 Dec 2017, 15:23
Forum: Ask For Help
Topic: connect to generated workbook and manipulate cell format
Replies: 0
Views: 206

connect to generated workbook and manipulate cell format

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...
by Geramont
30 Nov 2017, 16:02
Forum: Ask For Help
Topic: Running an Excel macro
Replies: 10
Views: 1688

Re: Running an Excel macro

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...
by Geramont
24 Nov 2017, 06:11
Forum: Ask For Help
Topic: Running an Excel macro
Replies: 10
Views: 1688

Re: Running an Excel macro

@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 ...
by Geramont
23 Nov 2017, 03:10
Forum: Ask For Help
Topic: Running an Excel macro
Replies: 10
Views: 1688

Re: Running an Excel macro

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...
by Geramont
16 Nov 2017, 16:41
Forum: Ask For Help
Topic: Running an Excel macro
Replies: 10
Views: 1688

Re: Running an Excel macro

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...
by Geramont
02 Nov 2017, 12:23
Forum: AHK Studio
Topic: AHK Studio
Replies: 1074
Views: 289414

Re: AHK Studio

@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...
by Geramont
30 Oct 2017, 10:32
Forum: AHK Studio
Topic: AHK Studio
Replies: 1074
Views: 289414

Re: AHK Studio

@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...
by Geramont
28 Oct 2017, 12:03
Forum: AHK Studio
Topic: AHK Studio
Replies: 1074
Views: 289414

Re: AHK Studio

@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...
by Geramont
27 Oct 2017, 13:38
Forum: Ask For Help
Topic: Running an Excel macro
Replies: 10
Views: 1688

Re: Running an Excel macro

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)
by Geramont
27 Oct 2017, 13:27
Forum: Ask For Help
Topic: Running an Excel macro
Replies: 10
Views: 1688

Re: Running an Excel macro

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...
by Geramont
27 Oct 2017, 12:47
Forum: AHK Studio
Topic: AHK Studio
Replies: 1074
Views: 289414

Re: AHK Studio / error on startup

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

Go to advanced search