PDA

View Full Version : Excel with different sheetname



clif
11-02-2011, 06:45 AM
I have a excel with different sheetname, and the sheetname will be changed by other people. I need to get all the data from each sheet in excel by vba. How to solve this problem ? Can anyone provide the code? Thanks!

mancubus
11-02-2011, 07:44 AM
if you want to combine all workseets in the workbook into one worksheet you can adop the procedure here.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=151