Hi everyone! Ive tried to search for best solution for my problem but failed to find one.
Basically what im trying to do is just a simple data entry in a website. What makes it complicated is that the rows, cell and data im copying keeps on changing and the web address as well. So what Im thinking is to just create a hotkey that I can activate when I already located the address to paste the data from excel.
Below is the sequence of the process:
1. IE Website is already open (Leave the cursor to the first textbox)
2. Go to excel file that was alredy open/lets assume (myfile.xls)
3. Go to row 4 copy data in cell b4, c4, d4, e4
5. Go to IE website
6. Paste the b4 data for the first textbox
7. Tab to move to next textbox paste c4
8. Tab to move to next textbox paste d4
9. Tab to move to next textbox paste e4
10. Go back tk excel and move to row 5 and repeat step 7 to 10.
Ive read some instructions about COM but find it too complicated for a beginner like me. Thank you so much for your patience and for your help.
- Home Board index AutoHotkey (v1.1 and older) Ask for Help (v1)
- Search
-
- It is currently 23 Apr 2024, 07:11
- All times are UTC-05:00
Copy data from excel to IE with changing rows and webaddress
Get help with using AutoHotkey (v1.1 and older) and its commands and hotkeys
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)