| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel files
I have two excel files. How do I write a procedure in one file that will
open the other file and be able to access the data in that file? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel files
Sub Open()
Workbooks.Open Filename:="File Path here such as C:\MyDocuments\File.xls" End Sub You can then call information from the open file. "ranswrt" wrote: I have two excel files. How do I write a procedure in one file that will open the other file and be able to access the data in that file? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel files
How would I copy a range of cells from one excel file to another?
Thanks "StumpedAgain" wrote: Sub Open() Workbooks.Open Filename:="File Path here such as C:\MyDocuments\File.xls" End Sub You can then call information from the open file. "ranswrt" wrote: I have two excel files. How do I write a procedure in one file that will open the other file and be able to access the data in that file? Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel files
See Ron de Bruin's CopyPasteMerge section for retrieving data from
multi-workbooks and multi-worksheets. http://www.rondebruin.nl/tips.htm Gord Dibben MS Excel MVP On Mon, 23 Jun 2008 16:45:01 -0700, ranswrt wrote: How would I copy a range of cells from one excel file to another? Thanks "StumpedAgain" wrote: Sub Open() Workbooks.Open Filename:="File Path here such as C:\MyDocuments\File.xls" End Sub You can then call information from the open file. "ranswrt" wrote: I have two excel files. How do I write a procedure in one file that will open the other file and be able to access the data in that file? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Navigating to Excel files over network slow, but not Word files | Excel Discussion (Misc queries) | |||
| Excel 2007 tmp files filling up drive with XLSM files | Excel Worksheet Functions | |||
| How to change default Open/Files of Type to "Microsoft Excel Files | Excel Discussion (Misc queries) | |||
| how to default WritePassword under excel workbook property for any files as long as those files are the offsprings of the parent file | Excel Programming | |||
| Drive Erased, got Files back but only excel files scrambled, help. | Excel Discussion (Misc queries) | |||
Linear Mode
