Budget: 70 USD Deadline: 3 days
Your task to automate work with the Clics program is clear to me.
I have experience creating similar macros for automating routine operations, I have written macros for video games.
What I understood from the task:
Macro 1 (Ctrl + combination):
Copies the client ID from the current Excel cell
Pastes it into the input field of the Clics program
Opens the record at a specific location in the program
Macro 2 (another combination):
Closes the current record in Clics
Moves to the next ID in the column (down one row)
Copies the new ID into Clics
Opens the next record
My experience with similar tasks:
I did a similar automation for the company "AuditPlus" - a macro transferred data from Excel to their accounting system "1C:Enterprise". Used Python + pyautogui to simulate user actions and work with program windows.
Technical approach:
I recommend Python with libraries:
pyautogui - for simulating clicks and text input
pynput - for global hotkeys
openpyxl - for working with Excel files
pygetwindow - for managing program windows
Workflow algorithm:
Monitoring hotkey presses
Determining the active cell in Excel
Finding and activating the Clics window
Automatic data entry and navigation
It is important to test on your system, as interface element coordinates may differ.
Additional information needed:
Screenshot of the Clics program interface
Example Excel table with data
Windows and Excel version
P.S. Similar macros save up to 80% of time on routine operations. After setup, you will be able to process client lists much faster.