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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transferring Excel Documents into a Workbook

Status
Not open for further replies.
FaaFee

FaaFee

Technical User
Joined
Jun 11, 2003
Messages
4
Location
US
If there anyway to move seperate excel files into a one workbook using a vbscript? (Prefably with each file on its own page)
 
Sort by date Sort by votes
You should be able to use VBA in one Excel Workbook to programatically open the others and copy them into the relevant sheets.

Check out for some info and links, the links on the conclusions page will probably help the most.
 
Upvote 0 Downvote
Thanks for the links. Will see if they can help me out.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Brianfree
  • Locked
  • Question Question
Excel Rows to Column
Replies
2
Views
805
Brianfree
Brianfree
asel
  • Locked
  • Question Question
Copy cell data from excel and paste into portable software application
Replies
0
Views
362
asel
asel
Nu2Java
  • Locked
  • Question Question
Copy Excel Columns to New Workbook
Replies
1
Views
555
SkipVought
S
S
  • Locked
  • Question Question
Need to submit page when clicking a checkbox
Replies
0
Views
637
shbr5413
S
NYCROB
  • Locked
  • Question Question
Error Permission Denied - Code 800A0046 - Copiend the Documents Folder
Replies
2
Views
503
NYCROB
NYCROB

Part and Inventory Search

Sponsor

Back
Top