Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import all sheets, without knowing their names
Hi All........
If someone would be so kind........I am in need of code to open a second Excel file, and import all of the several sheets therein into the first book. I do not know exactly how many sheets there are, nor their names.....but there are about 6-10 sheets in the second book. Upon importing them, I would like to assign each my own unique name, like XXX1, XXX2, etc. I know how to go and get sheets whose names I know, I just don't know how to get all of them when I don't know how many there are, nor their names. TIA for any assistance, Vaya con Dios, Chuck, CABGx3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import column names into top row | Excel Discussion (Misc queries) | |||
How to import names into Excel | Excel Discussion (Misc queries) | |||
Import file names | Excel Discussion (Misc queries) | |||
need to find a max count without knowing what I'm counting (list of names) | Excel Worksheet Functions | |||
Import file names into cells | Excel Worksheet Functions |