AutoHotkey and Excel - AutoHotkey Tutorial #10

This video tutorial shows, how to automate Excel with AutoHotkey. It shows how to open an Excel sheet, how work with data and variables and how to save the Excel sheet again. All done by a simple AutoHotkey script.

You could also watch:
🔵 The Beginner's Guide to AutoHotkey - https://youtu.be/AvzhaoDxd8Q
🔵 Install and Run your First AHK Script - https://youtu.be/k7e9MrP-U_g

0:05 Create our Excel ahk script in action
Our script will be Hotkey driven. We are creating a handle to a new Excel instance. We will set our Excel instance as visible, because Microsoft sets is as invisible per default. Furthermore we add a new workbook.

1:48 Open a specific Excel sheet
Instead of open a new Excel instance, we can open a saved Excel sheet instead with AutoHotkey.

2:46 Variable for our path
Instead of hard-coding our path, we can create a variable instead.

3:53 Let the user specify the Excel file to open
We use FileSelectFile to let the ahk user specify, which sheet to open.

5:10 Targeting our Excel instance
Using the AutoHotkey ComObjActive to target an open Excel sheet. We chose a specific cell (range) to write something in. Again we can use a variable instead of hard-coding.

7:35 Looping through an Excel column
Use a while loop to loop through our range.

11:10 Copy cells
We can use the ahk property 'Copy' to copy Excel cells.

11:54 Save an Excel sheet with AutoHotkey
We can either save our Excel sheet with an overwrite or save to a new path.

Connect with me:
🔔 Subscribe - http://www.youtube.com/user/klogeanders?sub_confirmation=1
💼 LinkedIn - https://www.linkedin.com/in/andersjensens/
👥 Facebook - https://www.facebook.com/andersjensenorg
💌 Email Newsletter - https://andersjensen.org/email-newsletter/

#autohotkey #ahk #scripting

Видео AutoHotkey and Excel - AutoHotkey Tutorial #10 канала Anders Jensen