PC Review


Reply
Thread Tools Rate Thread

Combining Two Workbooks

 
 
VETcalc
Guest
Posts: n/a
 
      4th Sep 2004
I have two applications that I would like to combine into one
workbook.

Is there away to do that?

Thanks,

Bo

--
Message posted from http://www.ExcelForum.com

 
Reply With Quote
 
 
 
 
Frank Kabel
Guest
Posts: n/a
 
      4th Sep 2004
Hi
not very specific: What kind of data do you want to combine, how is
your current data layout, etc.

--
Regards
Frank Kabel
Frankfurt, Germany


> I have two applications that I would like to combine into one
> workbook.
>
> Is there away to do that?
>
> Thanks,
>
> Bob
>
>
> ---
> Message posted from http://www.ExcelForum.com/


 
Reply With Quote
 
Ken Wright
Guest
Posts: n/a
 
      4th Sep 2004
If you mean you have two workbooks atht you would like to have as one, then open
both, then pick one and select all sheets by clicking on the first tab, holding
down SHIFT and then clicking on the last tab. Now right click, select Move or
Copy, then from the dialog box presented choose your other file from the
dropdown (Do NOT tick the create copy option, else you may end up creating
unwanted links between the files) and hit OK.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"VETcalc >" <<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have two applications that I would like to combine into one
> workbook.
>
> Is there away to do that?
>
> Thanks,
>
> Bob
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.747 / Virus Database: 499 - Release Date: 01/09/2004


 
Reply With Quote
 
Billy
Guest
Posts: n/a
 
      4th Sep 2004
Move all your code in workbook with XLA extension (and save it under
that extension). Then use reference to that file over Excel menu
Tools|Add-Ins..
You can call then any of your function to any your workbooks.

HTH
Billy

VETcalc <<(E-Mail Removed)>> wrote in message news:<(E-Mail Removed)>...
> I have two applications that I would like to combine into one
> workbook.
>
> Is there away to do that?
>
> Thanks,
>
> Bob
>
>
> ---
> Message posted from http://www.ExcelForum.com/

 
Reply With Quote
 
VETcalc
Guest
Posts: n/a
 
      4th Sep 2004
Frank, Ken & Billy,

Thank you for your replies.

Bo

--
Message posted from http://www.ExcelForum.com

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining Workbooks =?Utf-8?B?Um9ubmllRg==?= Microsoft Excel Charting 0 17th May 2007 08:40 PM
Combining Workbooks =?Utf-8?B?YmFuam9yZWFk?= Microsoft Excel Misc 4 14th Nov 2006 03:56 PM
Combining 3 workbooks to one =?Utf-8?B?U0lUQ0ZhblRO?= Microsoft Excel Programming 4 23rd Oct 2006 11:56 PM
combining many different workbooks =?Utf-8?B?d2hhdCB3ZXJlIHRoZXkgdGhpbmtpbmc=?= Microsoft Excel Misc 1 14th Jan 2006 09:05 AM
Combining 2 workbooks Kayth Microsoft Excel Worksheet Functions 2 24th May 2004 10:37 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:42 PM.