How import data from multi-tab Excel file
I have a multi-tab (worksheet) Excel file. The file has 79 worksheets total. Each worksheet has the exact same headers, and they are all named exactly the same. I could manually import or append all 79 of them into one table but that would take a long time.
What I really want to do is click a command button on a form that will loop through all of the worksheets in the Excel file AFTER is allows me to navigate to the Excel file, and import the data into a single table.
Is this even possible? If so I have no idea how to begin writing the code.
--Steve
What I really want to do is click a command button on a form that will loop through all of the worksheets in the Excel file AFTER is allows me to navigate to the Excel file, and import the data into a single table.
Is this even possible? If so I have no idea how to begin writing the code.
--Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Have a look at this page: http://www.extendoffice.com/documents/excel/1184-excel-merge-multiple-worksheets-into-one.html
It gives a solution in VBA code if you are OK with that, and a product to do the job for you if you are not.