Vba – Excel – Import Data
Hello
I need a macro (VBA in Access, no form needed).
You have to read many excel books and extrac the information in them, and store this in a table.
The path you will search in, is in the table “Path”
1. read “Path” and search all the excel files (xls and xlsx) that contains “*20 A.” (for example “072009 A.xls”)
2. fill in “registry” the information about wich file you are going to process (see more comments in “registry” design)
3. search inside the book sheets with name from 1 to 1000 (for example see excel file).
4. for each sheet, fill the information in table “analiticaOutput”. See “Analitica Output” design.
5. Only fill data if “euros” <>0
Attache
MDB file where you will find path and table for your output
072009 A.xls file (real example)
Example output.xlsx with a example of how it should look like the output.
Scrow payment
Access 2007.
Thanks
Pablo
