Excel: how to send in a userform multiple data

Get help with using AutoHotkey (v1.1 and older) and its commands and hotkeys
Luis Diaz
Posts: 28
Joined: 04 Jun 2020, 16:56

Excel: how to send in a userform multiple data

05 Apr 2023, 19:44

[Mod edit: Moved topic to AHK v1 help, based on posted code.]

Hello experts,

I have the following userForm. I would like to populate the table through a UserForm based on csv file. The idea is to enter the data multiple times based in CSV file through In the UserForm. If I have 5555 entry the action should be performed 5555 times.
The sequence can be as following:
1-Open Excel

Code: Select all

Excel32:="C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE"
Excel64:="C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE"
If (FileExist(Excel32))
  Run,%Excel32%
Else
If (FileExist(Excel64))
  Run,%Excel64%
Else
  MsgBox,4112,Error,Neither 32-bit nor 64-bit Excel exists on this system
Return
2-Read information of CSV file
3-Enter as CSV entry is reported in the file, one by one.
4-At Each entry AutoHotkey should click on Ok and continue.

Thank you for your help.

I attach reference files.
Attachments
Demo-05042023.csv
(391.16 KiB) Downloaded 13 times

[The extension xlsm has been deactivated and can no longer be displayed.]

Return to “Ask for Help (v1)”

Who is online

Users browsing this forum: arrondark, Theleifblower and 79 guests