ActiveDocument.Variables / ActiveWorkbook.?

[Vivien Parlat]

Hi,

While trying to save a string in an Excel Workbook, but NOT in any
cell, I discovered something exists to do that in Word,
"ActiveDocument.Variables".
Is there a similar way to store data in Excel, except CustomProperties
which are limited in size.

Thank you in advance.

 

[Daryl S]

Vivien -

You can store global variables in code modules in Excel. You can open them
by right-clicking on any worksheet tab and clicking on View Code. If you
don't know anything about Visual Basic, then I would suggest storing your
strings in cells in a separate worksheet and hide that worksheet.