Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with named Range in ADO extract from Closed Excel File
I have used the ADO method to extract cell data from a closed Excel
file in the past successfully but in my current efforts I am using a named range which does not appear on the first sheet (putting in a simple a1:d10 as the range does work but grabs front sheet). The argument in the call is like this: GetDataFromClosedWorkbook "C:\FolderName\WorkbookName.xls", "MyDataRange", Range ("B3"), True where MyDataRange is a range on the 10th sheet named "Projected" and has a first row which consists of AccountName,and then dates all the way across. The code errors out to the error handler at the line: Set rs = dbConnection.Execute("[" & SourceRange & "]") this is the source for the code - and the platform is xl2000 on win2000. http://www.erlandsendata.no/english/...mportwbado.htm Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with named range for a large spreadsheet in Excel 2007 | Excel Discussion (Misc queries) | |||
Problem with link to named range | Excel Discussion (Misc queries) | |||
Find in Named Range problem (2nd Try) | New Users to Excel | |||
HOW TO EXTRACT CELL REFERENCE AS TEXT FROM NAMED RANGE | Excel Worksheet Functions | |||
How do I use indirect when referring to a named range in a closed | Excel Worksheet Functions |