Seeking help for finding and retrieving values from Excel Workbooks using com object module?

Get help with using AutoHotkey and its commands and hotkeys
User avatar
Sabestian Caine
Posts: 251
Joined: 12 Apr 2015, 03:53

Seeking help for finding and retrieving values from Excel Workbooks using com object module?

09 Feb 2018, 13:07

Friends, i want to find and retrieve values from one excel workbook to another workbook. Say i have two workbooks- workbookA, which contains account numbers and their names and workbookB, in which i want to insert the retrieved values from workbookA. The workbookA from which i want to find and retrieve values looks like this-

WorkbookA-

Image

There are around 10 thousand account numbers and names in this workbook. I want that when i press numpadenter in workbookB, then it should first search the value (account number) of currently selected cell into workbookA and if it finds the account number in workbookA then it should retrieve the name of that account number into workbookB.

WorkbookB is something like this-

Image


My codes are these-


Code: [Select all] [Expand] [Download] GeSHi © Codebox Plus



However the above codes are working fine to some extent, but they are little bit slow and sometimes they stop working even. i have to press enter again and again that’s why i think they lag in performance. I want to know that is it a good way to retrieve values from an excel database like above? Or it is good way to create a database of account numbers and names into excel like the above? There is something else which can i do to increase its performance? Please help me. Thanks a lot..
I don't normally code as I don't code normally.
YOU do what YOU want, but happens what HE wants.
YOU do what HE wants, will happen what YOU want.

Return to “Ask For Help”

Who is online

Users browsing this forum: truekefir and 47 guests