ActiveDocument.Variables / ActiveWorkbook.?

  • Thread starter Thread starter Vivien Parlat
  • Start date Start date
V

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.
 
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.
 
Back
Top