If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importing unopened worksheet into an open Workbook
If an unopened Excel Workbook only contains a single worksheet, is it
possible to import the data from that worksheet into another Workbook that is open, without having to open the other file? |
#2
|
|||
|
|||
You can write formulas in the open workbook that refer to the cells in the 2nd
workbook, regardless of the number of worksheets it contains. This creates a "link" from workbook #1 to #2. If #2 isn't open when you open #1, you'll be asked whether to update the information from #2. This will happen without you seeing #2 appear on the screen. On Sat, 5 Mar 2005 15:33:03 -0800, "GrayesGhost" wrote: If an unopened Excel Workbook only contains a single worksheet, is it possible to import the data from that worksheet into another Workbook that is open, without having to open the other file? |
#3
|
|||
|
|||
Myrna,
I appreciate the reply, but I don't want to link the two workbooks. I want to physically insert the data from the unopend worksheet into a worksheet in another Workbook that is already open (similar to importing a text file - except I want to import an Excel Worksheet). Is it possible to do this? |
#4
|
|||
|
|||
Hi GrayestGhost-
Direct answer to your question is No. In order to move or copy sheets from one file to another, both files must be open. Even if you move or copy to a New workbook, tha wkbk will open as it is created. HTH |:) "GrayesGhost" wrote: If an unopened Excel Workbook only contains a single worksheet, is it possible to import the data from that worksheet into another Workbook that is open, without having to open the other file? |
#5
|
|||
|
|||
Well, if you are talking about Data/Import External Data, that might be
possible. If not, you would need to use a VBA macro do do this, but even then, you must open the 2nd workbook. However, the macro can turn off screen updating so the user doesn't see the 2nd book being opened and closed. BTW, unless you are talking about Data/Import External Data, you can't import a text file (#2) into an open workbook (#1) without a macro, either. If you just open the text file (#2), it goes into its own workbook, so at that point you have 2 workbooks open. To get it into book #1, you have to move or copy the worksheet from #2 to #1. On Sat, 5 Mar 2005 16:35:04 -0800, "GrayesGhost" wrote: Myrna, I appreciate the reply, but I don't want to link the two workbooks. I want to physically insert the data from the unopend worksheet into a worksheet in another Workbook that is already open (similar to importing a text file - except I want to import an Excel Worksheet). Is it possible to do this? |
#6
|
|||
|
|||
Taz,
That wasn't what I wanted to hear, but that does answer my question. I am a long time Quattro Pro user who is, unfortunately, having to now learn Excel. There are a lot of similarities between the two spread sheets but the differences are also as far apart as night and day. In Quattro Pro, it is possible to "insert" an unopened file into an open worksheet without having to first open the second file and then do a copy/paste. The project I am currrently working on involves combining data from several different, single sheet workbooks and that feature would be most helpful about now. Thanks for the reply - GrayesGhost "CyberTaz" wrote: Hi GrayestGhost- Direct answer to your question is No. In order to move or copy sheets from one file to another, both files must be open. Even if you move or copy to a New workbook, tha wkbk will open as it is created. HTH |:) "GrayesGhost" wrote: If an unopened Excel Workbook only contains a single worksheet, is it possible to import the data from that worksheet into another Workbook that is open, without having to open the other file? |
#7
|
|||
|
|||
The macro to do this would not be very complicated.
On Sat, 5 Mar 2005 19:25:02 -0800, "GrayesGhost" wrote: Taz, That wasn't what I wanted to hear, but that does answer my question. I am a long time Quattro Pro user who is, unfortunately, having to now learn Excel. There are a lot of similarities between the two spread sheets but the differences are also as far apart as night and day. In Quattro Pro, it is possible to "insert" an unopened file into an open worksheet without having to first open the second file and then do a copy/paste. The project I am currrently working on involves combining data from several different, single sheet workbooks and that feature would be most helpful about now. Thanks for the reply - GrayesGhost "CyberTaz" wrote: Hi GrayestGhost- Direct answer to your question is No. In order to move or copy sheets from one file to another, both files must be open. Even if you move or copy to a New workbook, tha wkbk will open as it is created. HTH |:) "GrayesGhost" wrote: If an unopened Excel Workbook only contains a single worksheet, is it possible to import the data from that worksheet into another Workbook that is open, without having to open the other file? |
#8
|
|||
|
|||
You haven't told us enough. If the other workbook contains a table, use
Data - Get external data. The process varies a bit with your release of Excel. You never have to open the workbook, and can refresh the import to reread the data at any time. You can also create a link without ever having opened the workbook (though it's easier if you do). =[workbookname.xls]'Sheet 1'!A1 Now copy this down and across, and you have the data. Once done, you never have to reopen the other workbook. A macro could parse the data, if necessary, put it where you want it, and do any other tasks. Without knowing more, that's the best I can suggest. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "GrayesGhost" wrote in message ... If an unopened Excel Workbook only contains a single worksheet, is it possible to import the data from that worksheet into another Workbook that is open, without having to open the other file? |
#9
|
|||
|
|||
I suggested formulas, too, but he rejected that with the statement that he
doesn't want to link the workbooks. I guess he's missing a feature from Quattro (or Lotus?) that he used frequently. It would be fairly simple to program what he wants. On Sat, 5 Mar 2005 23:19:00 -0500, "Earl Kiosterud" wrote: You haven't told us enough. If the other workbook contains a table, use Data - Get external data. The process varies a bit with your release of Excel. You never have to open the workbook, and can refresh the import to reread the data at any time. You can also create a link without ever having opened the workbook (though it's easier if you do). =[workbookname.xls]'Sheet 1'!A1 Now copy this down and across, and you have the data. Once done, you never have to reopen the other workbook. A macro could parse the data, if necessary, put it where you want it, and do any other tasks. Without knowing more, that's the best I can suggest. |
#10
|
|||
|
|||
Earl,
Maybe I don't know enough about Excell yet to word the question in a form that is understandable. What I am trying to do is to copy some statistics from several Workbooks that only contain a single work sheet. I want to combine the worksheets from multiple Excell workbooks into seperate worksheets in a single Workbook, and then get rid of all the original files. I know I can open each workbook seperately, copy the data from that workbook and paste it into seperate sheets in the file that I am compiling (that is what I have been doing) but I know there has to be an easier way - such as simply inserting the unopened file into a blank work sheet as I was able to do in Quattro Pro. (Menu: Insert/File/filename) = Inserted the desired file into one or more worksheets depending on whether or not the inserted file was a text file or an existing Quattro Pro workbook. I am now using MS Office 2000 Pro. I don't want to go to the trouble of writing formulas, or linking the current workbook to files that I am going to destroy once I have transfered the data - But I don't know of any other way to word the question - I think I pretty much have the answer anyway though - apparently Excell doesn't have the feature that I am looking for. Thanks again - GG "Earl Kiosterud" wrote: You haven't told us enough. If the other workbook contains a table, use Data - Get external data. The process varies a bit with your release of Excel. You never have to open the workbook, and can refresh the import to reread the data at any time. You can also create a link without ever having opened the workbook (though it's easier if you do). =[workbookname.xls]'Sheet 1'!A1 Now copy this down and across, and you have the data. Once done, you never have to reopen the other workbook. A macro could parse the data, if necessary, put it where you want it, and do any other tasks. Without knowing more, that's the best I can suggest. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "GrayesGhost" wrote in message ... If an unopened Excel Workbook only contains a single worksheet, is it possible to import the data from that worksheet into another Workbook that is open, without having to open the other file? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sumif Linking to Another Workbook error #VALUE! | Tunde | General Discussion | 16 | March 4th, 2005 03:02 AM |
Unprotect Workbook | Kent | General Discussion | 1 | February 4th, 2005 01:07 AM |
&[tab] Usage Twist | Jody | Worksheet Functions | 4 | January 10th, 2004 06:21 PM |
removing password protection | Sikora | Worksheet Functions | 6 | October 10th, 2003 02:09 PM |