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!

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

Importing details of multiple excel files into a new excel file

Status
Not open for further replies.

justin319

MIS
Apr 20, 2007
4
PH
hi my situation here is i have 16 excel files full of information and i want to import all their details into a new excel file. can u provide the code for me please? much appreciated.
 
Probably not, but here's a starting point:
Open the "new" spreadsheet.
Turn on the macro recorder.
Open one of the 16.
Manually perform the steps you want.
Stop the macro recorder.
Using Alt-F11, look at the code that was created.
Ask a specific question if you still need to.

_________________
Bob Rashkin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top