Hi got quick question. I'm trying to get an app that will allow me to GET DATA FROM AN EXCEL FILE INTO DOS LIKE PROGRAM. I have tried using auto clicking program however it works for one line and then it struggles to do another line/row.
I used ahk once and it was great but it was very simple, so just wondering if what I have just explained is possible in ahk.
So lets say I have a table in excel with following columns : part number, lot number, Customer lot, quantity, customer batch, pallet number, destination and example would look like : 0110032, 43252345, 43252345, 120, 42-2443502-32, 143243552, INBOUND01
Now the DOS like program that we are using basically needs user input but it works like following:
1.
We need to press F3 to generate a number and then enter to confirm.
2.
Now it will need the data from the EXCEL starting from the first column so part number which in this case is : 0110032
3.
It will display new line which needs us to press ENTER.
4.
Now it needs to paste second column : lot number
5.
Now it needs to paste third column : customer lot
6.
It will display new line and ask to press enter.
7.
Paste : Quantity
8.
Press Enter
9.
Paste : Customer batch
10.
Paste : Pallet number
11.
Press Enter
12.
Press : Y
13.
Press : 2
14.
Paste : Destination
15. And now the most important bit which I can not replicate on the auto clicker, which is to go down a row in the EXCEL file and just do it again, until no more rows / records found in excel.
Can you please help ?
- Home Board index AutoHotkey (v1.1 and older) Ask for Help (v1)
- Search
-
- It is currently 24 Apr 2024, 18:42
- All times are UTC-05:00
Pulling Data From Excel into DOS like program
Get help with using AutoHotkey (v1.1 and older) and its commands and hotkeys
-
- Posts: 3
- Joined: 14 Aug 2018, 12:39
Jump to
- AutoHotkey Foundation
- About This Community
- Forum Issues
- AutoHotkey (v2, current version)
- Ask for Help (v2)
- Gaming
- Scripts and Functions (v2)
- Gaming
- Tutorials (v2)
- Tips and Tricks
- Wish List
- Suggestions on Documentation Improvements
- Bug Reports
- AutoHotkey Development
- AutoHotkey_H
- Ask for Help
- Development
- Editors
- Adventure IDE
- Old Topics
- AHK Studio
- Notepad++
- Pulovers Macro Creator
- SciTE4AutoHotkey
- Visual Studio Code
- Announcements
- General Discussion
- AutoHotkey (v1.1 and older)
- Ask for Help (v1)
- Gaming Help (v1)
- Scripts and Functions (v1)
- Gaming Scripts (v1)
- Tutorials (v1)
- Tips and Tricks (v1)
- General
- Other Utilities & Resources
- Other Programming Languages
- C/C++
- ASM
- C#
- KeySharp
- Off-topic Discussion
- RPA
- Other languages
- Looking for Volunteers in other languages
- Deutsch (German)
- Ich brauche Hilfe
- Spiele
- Skripte und Funktionen
- Tutorials
- Tooltime
- Allgemeines
- 中文 (Chinese)
- 请求帮助
- 脚本函数
- 教程资料
- 相关工具
- 其他
- Español (Spanish)
- Pedir Ayuda
- Automatización de Juegos
- Scripts y Funciones
- Tutoriales
- Otras Utilidades y Recursos
- General
- Русский (Russian)
- Помощь
- Скрипты для Игр
- Скрипты и библиотеки
- Статьи и руководства
- Прочие ресурсы и ПО.
- Свободное общение
- Français (French)
- J'ai besoin d'aide
- Scripts et Fonctions
- Tutoriels
- Autres Utilitaires et Ressources
- Hors Sujet
- Português (Portuguese)
- Ajuda e Suporte Geral
- Scripts e Funções
- Tutoriais
- Outras Ferramentas e Recursos
- Outros Assuntos
- 한국어 (Korean)
Who is online
Users browsing this forum: No registered users and 218 guests