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

  • Thread starter Thread starter Don
  • Start date Start date
D

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?
 
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?
 
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
 
Make it volatile?

--


Regards,


Peo Sjoblom

Rick Rothstein (MVP - VB) said:
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
Click to expand...
 
Is that something one would normally want for this kind of function? What
does it being volatile do for its functionality?

Rick
 
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?
| >>
| >
| >
|
 
Back
Top