Hello,

I'm building an add-in for Excel. I need to store information about the
file into the workbook. I also build this add-in for Word and here you
can add document variables.

I've read about names variable but the value of that needs to be stored
into a cell. I don't want to store it in a cell, so can someone tell me
if there is a way to store the information like I did in Word.

regards,
Gertjan de Vrij

You can use defined=Names in VBA without using them in a cell.

Excel also has builtindocumentproperties and customdocumentproperties same
as Word if that is what you are talking about.

--
Regards,
Tom Ogilvy


" wrote:

Hello,

I'm building an add-in for Excel. I need to store information about the
file into the workbook. I also build this add-in for Word and here you
can add document variables.

I've read about names variable but the value of that needs to be stored
into a cell. I don't want to store it in a cell, so can someone tell me
if there is a way to store the information like I did in Word.

regards,
Gertjan de Vrij