| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select range from unopened workbook
I'm trying to take data from an unopened workbook. I copied the
following code directly from my "Excel 2003 VBA" book. range("A12") = Workbooks("BILLRATE.xls").Worksheets("BILLRATE").C ells(1, 1).range("A1") I get a "subscript out of range error on this. The workbook "BILLRATE" is in the working folder. And I can call it if I use Workbooks("BILLRATE.xls").Open. But when I try to access the range, I get the subscript out of range error. Any ideas? thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select range from unopened workbook
Make sure your spelling of the names is accurate. Make sure you actually
have a sheet named BILLRATE in the workbook. As a side note, why not just use Range("A1") for your cell reference rather than the duplicative Cells(1, 1).Range("A1")? It does the same thing and saves space. "Andrew" wrote in message ... I'm trying to take data from an unopened workbook. I copied the following code directly from my "Excel 2003 VBA" book. range("A12") = Workbooks("BILLRATE.xls").Worksheets("BILLRATE").C ells(1, 1).range("A1") I get a "subscript out of range error on this. The workbook "BILLRATE" is in the working folder. And I can call it if I use Workbooks("BILLRATE.xls").Open. But when I try to access the range, I get the subscript out of range error. Any ideas? thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select range from unopened workbook
hi
the line of code you are using is for open workbooks. to get data from a closed workbook, you will have to use ADO. See this site. http://www.rondebruin.nl/ado.htm Regards FSt1 "Andrew" wrote: I'm trying to take data from an unopened workbook. I copied the following code directly from my "Excel 2003 VBA" book. range("A12") = Workbooks("BILLRATE.xls").Worksheets("BILLRATE").C ells(1, 1).range("A1") I get a "subscript out of range error on this. The workbook "BILLRATE" is in the working folder. And I can call it if I use Workbooks("BILLRATE.xls").Open. But when I try to access the range, I get the subscript out of range error. Any ideas? thanks . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select range from unopened workbook
Unless
range("A12").formula="=[BILLRATE.xls].BILLRATE!A1" -- =[20100201.xls]Sheet1!$E$13 Don Guillett Microsoft MVP Excel SalesAid Software "FSt1" wrote in message ... hi the line of code you are using is for open workbooks. to get data from a closed workbook, you will have to use ADO. See this site. http://www.rondebruin.nl/ado.htm Regards FSt1 "Andrew" wrote: I'm trying to take data from an unopened workbook. I copied the following code directly from my "Excel 2003 VBA" book. range("A12") = Workbooks("BILLRATE.xls").Worksheets("BILLRATE").C ells(1, 1).range("A1") I get a "subscript out of range error on this. The workbook "BILLRATE" is in the working folder. And I can call it if I use Workbooks("BILLRATE.xls").Open. But when I try to access the range, I get the subscript out of range error. Any ideas? thanks . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select range from unopened workbook
but then if the workbook were closed(not opened) excel would insert the
entire file path. regards FSt1 "FSt1" wrote: hi you are right. but nothing in his post made me think of that. so i guess i got turned around. regards FSt1 "Don Guillett" wrote: Unless range("A12").formula="=[BILLRATE.xls].BILLRATE!A1" -- =[20100201.xls]Sheet1!$E$13 Don Guillett Microsoft MVP Excel SalesAid Software "FSt1" wrote in message ... hi the line of code you are using is for open workbooks. to get data from a closed workbook, you will have to use ADO. See this site. http://www.rondebruin.nl/ado.htm Regards FSt1 "Andrew" wrote: I'm trying to take data from an unopened workbook. I copied the following code directly from my "Excel 2003 VBA" book. range("A12") = Workbooks("BILLRATE.xls").Worksheets("BILLRATE").C ells(1, 1).range("A1") I get a "subscript out of range error on this. The workbook "BILLRATE" is in the working folder. And I can call it if I use Workbooks("BILLRATE.xls").Open. But when I try to access the range, I get the subscript out of range error. Any ideas? thanks . . |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select range from unopened workbook
so?
-- Don Guillett Microsoft MVP Excel SalesAid Software "FSt1" wrote in message ... but then if the workbook were closed(not opened) excel would insert the entire file path. regards FSt1 "FSt1" wrote: hi you are right. but nothing in his post made me think of that. so i guess i got turned around. regards FSt1 "Don Guillett" wrote: Unless range("A12").formula="=[BILLRATE.xls].BILLRATE!A1" -- =[20100201.xls]Sheet1!$E$13 Don Guillett Microsoft MVP Excel SalesAid Software "FSt1" wrote in message ... hi the line of code you are using is for open workbooks. to get data from a closed workbook, you will have to use ADO. See this site. http://www.rondebruin.nl/ado.htm Regards FSt1 "Andrew" wrote: I'm trying to take data from an unopened workbook. I copied the following code directly from my "Excel 2003 VBA" book. range("A12") = Workbooks("BILLRATE.xls").Worksheets("BILLRATE").C ells(1, 1).range("A1") I get a "subscript out of range error on this. The workbook "BILLRATE" is in the working folder. And I can call it if I use Workbooks("BILLRATE.xls").Open. But when I try to access the range, I get the subscript out of range error. Any ideas? thanks . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing Range in UnOpened Workbook | Excel Programming | |||
| Unopened workbook | Excel Discussion (Misc queries) | |||
| Importing Data from unopened Workbook into an open Workbook | Excel Discussion (Misc queries) | |||
| Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
| Unopened workbook values | Excel Programming | |||
![Andrew[_56_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
