Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Document variable in Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Document variable in Excel
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Document variable in Excel
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Document variable in Excel
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a formatted 'readable' document based on Excel document? | Excel Discussion (Misc queries) | |||
how do I import variable data into a word document | Excel Discussion (Misc queries) | |||
Variable IMAGE in document header | Excel Discussion (Misc queries) | |||
Move sheet to another document with variable name | Excel Programming | |||
Assign a variable to a word document | Excel Programming |