Good Afternoon everyone, I'm kinda new using AutoHotKey and I was wondering, is there any way in which you create a script that can change the active sheet so the macros that was created on that Workbook works correctly?
btw the workbook is macros enabled.
I tried the following
!i::
xlFile := A_ScriptDir "\Templates.xlsm"
oExcel.Sheets("Ticket Creation Templates").Select
Macro := "Templates.xlsm!INCIDENT"
try xlApp := ComObjActive("Excel.Application")
catch
{
xlApp := ComObjCreate("Excel.Application")
xlApp.WorkBooks.Open(A_AppData "\Microsoft\Excel\XLSTART\PERSONAL.XLSB")
}
xlApp.Visible := true
xlApp.Run(Macro)
send, ^v
Return
However the macros created run in different layouts from the sheets.
please advise guys!!! I really appreaciate it
- Home Board index AutoHotkey (v1.1 and older) Ask for Help (v1)
- Search
-
- It is currently 04 May 2024, 02:06
- All times are UTC-05:00
Run Macros from an excel to an especific spreadsheet HELP!!!
Get help with using AutoHotkey (v1.1 and older) and its commands and hotkeys
-
- Posts: 1
- Joined: 16 Nov 2017, 14:49
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)