Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Merge or Copy multiple Workbooks into one

Status
Not open for further replies.
denko

denko

Programmer
May 17, 2001
70
US
Is it possible to read multiple (I’ve got more then 100) Excel files and than copy them into one?
To be more clear I have Excel files with some sensible data.
I'm not sure if I need to open one of them copy the content into Main file close first file, open second one copy into main and so on. May be there is a more efficient way of doing it?
Any thoughts.

Thanks.
 
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
2K
Andrzejek
Andrzejek
btamsgn
  • Locked
  • Question
How to edit column chitoi into TableA
Replies
0
Views
154
btamsgn
btamsgn
Moss100
  • Locked
  • Question
Add multiple contacts to outlook - from access table
Replies
12
Views
426
Moss100
Moss100
Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
209
combo
combo
JimLes
  • Locked
  • Question
Access VBA Mail Merge Split to PDF and Word
Replies
12
Views
411
JimLes
JimLes

Part and Inventory Search

Sponsor

Back
Top