Hey, wondering if any of you guys can help me, basically for my job sometimes I have to fill in DHL forms for bank confirmations and other documents to different countries, and after getting sick of entering 20+ forms, I downloaded autohotkey to try to make this process less painful. I'm relatively new to the program, but I managed to learn how to copy cells from excel to paste into the web dhl mailing form for me. Problem is, I don't know how to copy the next column of data, that I usually just ctrl+h and find and replace the cell values of my code. I think their should be a way to loop it add 1 to the cell value column, but I am not sure how to do it and after googling and searching these forums I can't find a solution either, would any of you guys be able to help me? Here is what I have for reference, it's really basic, any help appreciated.
^q:: ;control q
wbk := ComObjGet("C:\Users\Name\Desktop\target\DHL source file.xlsx")
CompanyName := wbk.Sheets("sheet1").Cells(8, 28).Value
FirstLine := wbk.Sheets("sheet1").Cells(9, 28).Value
SecondLine := wbk.Sheets("sheet1").Cells(10, 28).Value
ThirdLine := wbk.Sheets("sheet1").Cells(11, 28).Value
CountryName := wbk.Sheets("sheet1").Cells(16, 28).Value
RecipientName:= wbk.Sheets("sheet1").Cells(14, 28).Value
RecipientPhoNo:= wbk.Sheets("sheet1").Cells(15, 28).Value
RecipientEmail:= wbk.Sheets("sheet1").Cells(13, 28).Value
SenderName := wbk.Sheets("sheet1").Cells(4, 1).Value
SenderExtNo := wbk.Sheets("sheet1").Cells(6, 1).Value
;Enter sender name
Send, {Tab}{Tab}{Tab}{Tab}
SendInput, % SenderName
;Enter sender phone number
Send, {Tab}{Tab}{Tab}{Tab}{Tab}{Tab}{Tab}
SendInput, % SenderExtNo
;Enter Company Name
Send, {Tab}
SendInput, % CompanyName
;Enter First Line
Send, {Tab}
SendInput, % FirstLine
;Enter Address Second Line
Send, {Tab}
SendInput, % SecondLine
;Enter Address Third Line
Send, {Tab}
SendInput, % ThirdLine
;Enter Country
Send, {Tab}
SendInput, % CountryName
;Enter Contact Person
Send, {Tab 3}
SendInput, % RecipientName
;Enter Contact Phone number
Send, {Tab 2}
SendInput, % RecipientPhoNo
;Enter Contact Email
Send, {Tab}
SendInput, % RecipientEmail
;Return to city selection
Send, +{Tab 5}
return
- Home Board index AutoHotkey (v1.1 and older) Ask for Help (v1)
- Search
-
- It is currently 28 Mar 2024, 04:00
- All times are UTC-05:00
Help on Looping copying excel cells and pasting in webform
Get help with using AutoHotkey (v1.1 and older) and its commands and hotkeys
-
- Posts: 1
- Joined: 04 Feb 2019, 03:32
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: CastleChou, Google [Bot], jaka1 and 132 guests