instal the last version for windows Macro Recorder 3.0.42

With ActiveWorkbook.Sheets(1).QueryTables.Add(Connection:='TEXT ' & csv_path, Destination:=Range('A1')) You can control what format is used for each column when you import a CSV file, but it's fiddly, and for many purposes we'd just like to load a CSV and have every column to be read in as uninterpreted text, without having to faff with the import wizard. PS: The windowfocus command is required for most other commands to work.Importing a CSV into Excel is annoying, because by default it will try to interpret the columns, and it often/usually gets it wrong. If you change your desktop settings such as font size or reinstall your system, they might stop working and would require adjustment. Of course, although such scripts are much more robust than recorded macros, they are by no means portable.

a defined window size (if click points change with different sizes).

the window id (only if your window title is not unique).

Start Sakura with the custom name xdowindow and start the xdotool script in it: sakura -t xdowindowįor your own script you would need the following: The sleep commands are just to slow it down to a watchable speed. I tried to get this working with gnome-terminal but gnome-terminal has been a major failure for some time and since then its window title cannot be changed, so I used Sakura for testing instead. This is a sample script for xdotool: search -name xdowindow You would have to calculate the offset.Ĭreate a text file for your xdotool script. Keep in mind that on Ubuntu you usually cannot move your window to the coordinates 0,0. Xterm -hold -e /usr/bin/xdotool getmouselocation To get the right position for your clicks you can move your window into the top left corner and use: ALT+F2

You can even execute commands from within a pure xdotool script and close their window after the job is done. With xdotool could identify windows and manipulate them to your parameters, and then program clicks relative to them, ignoring their position. I know this may not be what you are wishing for but it may be the best solution.Ī recorded macro would fail with missing windows, different window sizes etc.

It gives you far more control over the process.įrom your description, I assume that you need something more permanent and not a macro that is only used a few times after recording it. Instead of recording a macro, it might be more useful to script it from scratch with xdotool.

Instal the last version for windows Macro Recorder 3.0.42