Menu

Import all sheets, without knowing their names

Search this Thread

Prev

Previous Post

Next Post

Next

#7

Report Post

Posted to microsoft.public.excel.programming

Don Guillett Don Guillett is offline

Don Guillett is offline

external usenet poster

Posts: 10,124

Default

Import all sheets, without knowing their names

Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"CLR" wrote in message
...
Many thanks to all who responded.......many good suggestions
there,......in
the end, Don's suggestion struck my fancy so I went with it and all is
well
now.........

Thanks Don, and thanks to Mike, Merle, and Jim as well......you guys are
all
fantastic.

Vaya con Dios,
Chuck, CABGx3

"CLR" wrote in message
...
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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Import column names into top row	Mark909	Excel Discussion (Misc queries)	1	January 26th 09 12:21 PM
How to import names into Excel	Rahul	Excel Discussion (Misc queries)	3	April 18th 06 07:04 AM
Import file names	S.G.Pillai	Excel Discussion (Misc queries)	4	September 28th 05 04:11 PM
need to find a max count without knowing what I'm counting (list of names)	KR	Excel Worksheet Functions	2	July 25th 05 11:31 PM
Import file names into cells	craigwojo	Excel Worksheet Functions	2	November 2nd 04 11:19 PM

All times are GMT +1. The time now is 06:49 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement