Hi All,
sorry to asking using this threads link..
i had try the code but why always delete/replace previously list of documents..
just works with some list , about 8 -12 rows below
need help to display all of documents.
thank you
sorry to asking using this threads link..
How to open an excel file from the folder based on cell value
Hi, I have one excel file. In column A, I have values such as ABC1200, DEF1300 etc. I have a folder, this folder has multiple excel files. File names will be XYZ-ABC1200, UJM-DEF1300. For example, cell A1 value is ABC1200, the macro should copy this value, go to folder. Search this value...
chandoo.org
i had try the code but why always delete/replace previously list of documents..
just works with some list , about 8 -12 rows below
need help to display all of documents.
thank you