| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is transfer data from one Excel file to another possible?
I have a named range in my €˜FileA.xls file that references an array of data.
But say if Im working in €˜FileB.xls and €˜FileA.xls is closed, is there any way in VB to call out and import the named range from €˜FileA.xls into €˜FileB.xls? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is transfer data from one Excel file to another possible?
Hi EA
See if the information at http://www.beyondtechnology.com/geeks023.shtml is helpful. Jim P "EA" wrote: I have a named range in my €˜FileA.xls file that references an array of data. But say if Im working in €˜FileB.xls and €˜FileA.xls is closed, is there any way in VB to call out and import the named range from €˜FileA.xls into €˜FileB.xls? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is transfer data from one Excel file to another possible?
It seems as thought I'm almost there, but for some reason VB is not taking
this line: Private Sub GetData ("C:\Documents and Settings\Admin\Desktop\My File.xls", "Data", "Data_Range", Sheet1.Cells(1, 3), True) Do I have something wrong here? Thank you so much!!! "JH Palmer" wrote: Hi EA See if the information at http://www.beyondtechnology.com/geeks023.shtml is helpful. Jim P "EA" wrote: I have a named range in my €˜FileA.xls file that references an array of data. But say if Im working in €˜FileB.xls and €˜FileA.xls is closed, is there any way in VB to call out and import the named range from €˜FileA.xls into €˜FileB.xls? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is transfer data from one Excel file to another possible? | Excel Discussion (Misc queries) | |||
| I want to transfer a data base file into Excel then do mail merge | Excel Discussion (Misc queries) | |||
| How can I transfer a Lotus 123-9 data spread sheet file to Excel? | Setting up and Configuration of Excel | |||
| How do I transfer data in a pdf file into an excel workbook? | Excel Discussion (Misc queries) | |||
| Use ADO to transfer data from open excel file to closed excel file | Excel Programming | |||
Linear Mode
