| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
GetValue - Closed Workbook?
Prior to XL 2007 in order to retreive the value for a closed wb one had to
use an XLM macro. Has/Did the use of GetValue = ExecuteExcel4Macro(arg) been replaced in 2007? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
GetValue - Closed Workbook?
No, it is still the same. Are you having a problem with it?
-- __________________________________ HTH Bob "JMay" wrote in message ... Prior to XL 2007 in order to retreive the value for a closed wb one had to use an XLM macro. Has/Did the use of GetValue = ExecuteExcel4Macro(arg) been replaced in 2007? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
GetValue - Closed Workbook?
No, I'm not having a problem. I just cam across the UDF in my file, and got
to wondering... Am surprised that this technology is still around. It speaking to how advanced it was 20 years ago... LOL Thank, Jim "Bob Phillips" wrote: No, it is still the same. Are you having a problem with it? -- __________________________________ HTH Bob "JMay" wrote in message ... Prior to XL 2007 in order to retreive the value for a closed wb one had to use an XLM macro. Has/Did the use of GetValue = ExecuteExcel4Macro(arg) been replaced in 2007? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup last used Row un closed Workbook | Excel Worksheet Functions | |||
| Getvalue from closed workbook | Excel Discussion (Misc queries) | |||
| Linking to a closed workbook | Excel Worksheet Functions | |||
| Value from a closed workbook | Excel Discussion (Misc queries) | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
Linear Mode
