| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to set up an internal link between two excel files?
for example, I have two excel files, excel1 and excel2.
In excel2, I have written some functions, like it takes the values from column A, multiply it with 2, and save the results on column B. Too simple? In excel1, I give the values to column A of excel2, my purpose is to read the corresponding cells in column B, so that I can get the calculated results. (excel2 should not be opened) how to write this excel1 with VBA? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get cell data in multiple Excel files into one summary fi | Excel Worksheet Functions | |||
| How to remove link to other files in Excel 2000 | Excel Discussion (Misc queries) | |||
| Insert & link a graphic file in Excel 2003 -- updatable pictures! | Excel Discussion (Misc queries) | |||
| CHK file in excel link files | Excel Worksheet Functions | |||
| how do i link 2 excel files? | New Users to Excel | |||
Linear Mode
