hi,
In word object model there is Document.variables. Is there somthing
corresponding in Excel? If not can anybody tell me an alternative approch?

Regards,
Abhilash

There is nothing directly corresponding in Excel, but there is an
alternative: create a worksheet - hide it if you wish - and store any
"variables" in there as cell values. You should be able to accomplish the
same thing this way.
--
- K Dales


"news.microsoft.com" wrote:

hi,
In word object model there is Document.variables. Is there somthing
corresponding in Excel? If not can anybody tell me an alternative approch?

Regards,
Abhilash

i think Name object corresponds. as variable that belongs to a document.
Name object has a formula that returns a number, text, cell reference,
array, etc.
for instance, we can use a defined name(e.g. 'Customer')
instead of cell address(e.g. 'B2') in a formula put into a cell.

Variable Object -- Word 2003 VBA Language Reference
http://msdn.microsoft.com/library/en...HV05214028.asp

Name Object [Excel 2003 VBA Language Reference]
http://msdn.microsoft.com/library/en...HV05203124.asp

--
HTH

okaizawa


news.microsoft.com wrote:
hi,
In word object model there is Document.variables. Is there somthing
corresponding in Excel? If not can anybody tell me an alternative approch?

Regards,
Abhilash

Thank you both i am going in favour of names instead of hide a worksheet.

Regards,
Abhilash


"okaizawa" wrote in message
...
i think Name object corresponds. as variable that belongs to a document.
Name object has a formula that returns a number, text, cell reference,
array, etc.
for instance, we can use a defined name(e.g. 'Customer')
instead of cell address(e.g. 'B2') in a formula put into a cell.

Variable Object -- Word 2003 VBA Language Reference
http://msdn.microsoft.com/library/en...HV05214028.asp

Name Object [Excel 2003 VBA Language Reference]
http://msdn.microsoft.com/library/en...HV05203124.asp

--
HTH

okaizawa


news.microsoft.com wrote:
hi,
In word object model there is Document.variables. Is there somthing
corresponding in Excel? If not can anybody tell me an alternative
approch?

Regards,
Abhilash