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