ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   GetValue - Closed Workbook? (https://www.excelbanter.com/excel-discussion-misc-queries/208762-getvalue-closed-workbook.html)

JMay

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?


Bob Phillips[_3_]

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?




JMay

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?






All times are GMT +1. The time now is 09:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com