PDA

View Full Version : how to connect one excel file to another?



maryam
06-07-2007, 04:52 AM
I want to get data from another excel file and input in my excel file. How can I do that?

sujittalukde
06-07-2007, 05:56 AM
Your qwery is not explanatory. Plz explain more

lucas
06-07-2007, 06:02 AM
copy a range, a few cells, a sheet.
to a new sheet, existing sheet...??

maryam
06-07-2007, 06:30 PM
can it be done automatically, not by manual copy and paste?

lucas
06-07-2007, 06:36 PM
It can be done with a macro...from an open workbook you can open a closed workbook and copy a range into the first workbook..

mdmackillop
06-08-2007, 06:16 AM
Your qwery is not explanatory. Plz explain more
Agreed.
Are you looking to copy data, to link cells or something different entirely? Are you dealing with open or closed workbooks?

Cyberdude
06-09-2007, 12:10 PM
If I understand your question, you just want to do simple linking from a cell in one workbook to a cell in another. If that's what you want, then use a formula similar to this one:

='C:\EXCEL Documents\[China Stocks.xls]StkNames'!$K$22

where: 'C:\EXCEL Documents\[China Stocks.xls]
is the primary portion of the path to the workbook,
StkNames is the worksheet name, and
$K$22 is the desired cell on the worksheet.
Please take note of the positions of the two single quotes ('), the exclamation point (!), and the two brackets ([ ]). They are all essential and MUST be placed as shown.

This type of reference can be used to link to another workbook that is open or closed.