=GET.WORKBOOK(1+0*NOW())

[Don]

When i use =GET.WORKBOOK(1+0*NOW()) and I try to save to xlsx format (Excel
2007), i get an error stating that an Excel 4.0 macro cannot be saved in a
macro-free workbook. Is there an excel 2007 version of get.workbook that can
be saved in a macro-free workbook?

 

[Jim Rech]

Is there an excel 2007 version of get.workbook that can be saved in a
Since an Excel 4 macro is a macro a macro-free workbook cannot contain one.
Pick XLSM or XLSB or XLS.

--
Jim
| When i use =GET.WORKBOOK(1+0*NOW()) and I try to save to xlsx format
(Excel
| 2007), i get an error stating that an Excel 4.0 macro cannot be saved in a
| macro-free workbook. Is there an excel 2007 version of get.workbook that
can
| be saved in a macro-free workbook?

 

[Don]

thanks, new to excel 2007 and never thought about the xlsb.

 

[Rick Rothstein \(MVP - VB\)]

Just out of curiosity, what is the purpose of multiply NOW() by zero...
won't that **always** produce zero for that part of the expression?

Rick

 

[Peo Sjoblom]

Make it volatile?

--


Regards,


Peo Sjoblom

Just out of curiosity, what is the purpose of multiply NOW() by zero...
won't that **always** produce zero for that part of the expression?

Rick

 

[Rick Rothstein \(MVP - VB\)]

Is that something one would normally want for this kind of function? What
does it being volatile do for its functionality?

Rick

 

[Jim Rech]

If you define a name, say "x", as that formula and enter =x in a cell, it
will update with every calc (returning the workbook/worksheet name).
Without the 0*Now() it doesn't update with a calc so it would not reflect a
change in workbook or worksheet name.

--
Jim
message | Is that something one would normally want for this kind of function? What
| does it being volatile do for its functionality?
|
| Rick
|
|
| | > Make it volatile?
| >
| > --
| >
| >
| > Regards,
| >
| >
| > Peo Sjoblom
| >
in
| > message | >> Just out of curiosity, what is the purpose of multiply NOW() by zero...
| >> won't that **always** produce zero for that part of the expression?
| >>
| >> Rick
| >>
| >>
| >> | >>> When i use =GET.WORKBOOK(1+0*NOW()) and I try to save to xlsx format
| >>> (Excel
| >>> 2007), i get an error stating that an Excel 4.0 macro cannot be saved
in
| >>> a
| >>> macro-free workbook. Is there an excel 2007 version of get.workbook
| >>> that can
| >>> be saved in a macro-free workbook?
| >>
| >
| >
|

 

[Rick Rothstein \(MVP - VB\)]

I get it now... thanks.

Rick