My Assistant
Site Message
(Message will auto close in 2 seconds)
 Combining Workbooks
|
|
 Mar 30 2012, 02:15 PM
Post
#1
|
|
|
UtterAccess Veteran Posts: 337  |
Hi,
How do I combine two workbooks to become 1? For example I want workbook1.xls & workbook2.xls to be one. Thanks |
 |
 
|
 |
Replies
|
Mar 30 2012, 02:33 PM
Post
#2
|
|
|
UtterAccess Certified! Posts: 7,207 From: Arizona, United States |
So, if you have 3 sheets in book1, and 4 sheets in book2, then the NewBook3 will send up with 7 sheets right? That's OK?
Except each one of the 7 sheets will be only VALUES from the original source? Do I understand that right too? sorry! just want to make sure. |
|
|
|
Posts in this topic
John_Ross Combining Workbooks Mar 30 2012, 02:15 PM
ipisors from where do you want to run the VBA? From one o... Mar 30 2012, 02:16 PM John_Ross I don't have a VBA. I was thinking something ... Mar 30 2012, 02:18 PM ipisors QUOTE I don't have a VBA I'm sorry, I don... Mar 30 2012, 02:23 PM John_Ross I don't mind using VBA, what I meant was I don... Mar 30 2012, 02:27 PM ipisors Ok thanks, so my second question then is, what do ... Mar 30 2012, 02:28 PM John_Ross Yes! Exactly what I want. I want to retain t... Mar 30 2012, 02:32 PM John_Ross Exactly! Mar 30 2012, 02:35 PM ipisors Oh and the last question you haven't answered ... Mar 30 2012, 02:38 PM John_Ross A totally separate workbook. Mar 30 2012, 02:39 PM
ipisors Here is some code that should work for you - paste... Mar 30 2012, 02:52 PM |
 |
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 19th June 2013 - 06:48 PM |