Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DGET Function + External data from another excel file
Hello,
I'm trying to use the function DGET and get data from another excel worksheets and it doesn't seems to work. Does this looks correct : DGET ('c:\tmp\[tmp_excel.xls]'!A1:D20;"ID";A1:A2) ? thanks in advance ! Nader |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DGET Function + External data from another excel file
Nader wrote...
I'm trying to use the function DGET and get data from another excel worksheets and it doesn't seems to work. Does this looks correct : DGET ('c:\tmp\[tmp_excel.xls]'!A1:D20;"ID";A1:A2) You should state how it doesn't work. In this case, there are two problems. First, there's a syntax error. Your external reference is either missing a worksheet name before the exclamation point, or if the file has a single worksheet named tmp_excel then you shouldn't have the square brackets around the base filename. Second, DGET's first argument must be a range reference. Excel doesn't consider references into closed workbooks to be range references. That means you can't use DGET (or any of the other D... functions) to refer to blocks of cells in other workbooks that could be closed. There are workarounds, but you'll need to provide the A1:D1 values (field names) from the other file and the contents of the criteria range. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DGET Function + External data from another excel file
It looks like it is missing the worksheet name, something like:
DGET ('c:\tmp\[tmp_excel.xls]Sheet1'!A1:D20;"ID";A1:A2) If the sheet is not called Sheet1, change as required Hope this helps, Miguel. "Nader" wrote: Hello, I'm trying to use the function DGET and get data from another excel worksheets and it doesn't seems to work. Does this looks correct : DGET ('c:\tmp\[tmp_excel.xls]'!A1:D20;"ID";A1:A2) ? thanks in advance ! Nader |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
Get External Data in Excel | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
no data in excel file | Excel Discussion (Misc queries) |