Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel equivalent to Word Variable
Can anyone tell me if excel has an in built variable for
each workbook simular to the words Activedocument.Variables("") If so what is it please i cannot seem to find and referance to such a variable. If not does anyone know of a way of storing information in a variable that is specific only to that workbook. Thanks in anticipation. Fred |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel equivalent to Word Variable
Hi
one way would be to use the property CustomDocumentProperties of your workbook (see the VBA help for this topic) You may also consider defining a name (menu: 'Insert - Name - Define') and use this to store your variables -----Original Message----- Can anyone tell me if excel has an in built variable for each workbook simular to the words Activedocument.Variables("") If so what is it please i cannot seem to find and referance to such a variable. If not does anyone know of a way of storing information in a variable that is specific only to that workbook. Thanks in anticipation. Fred . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel equivalent to Word Variable
Thanks chaps for your help
Fred -----Original Message----- You can use 2 ways: activeworkbook.Names.Add "ajay","100" ?activeworkbook.names("ajay").Value =100 Note that the values of variables are always strings and have a perfix =. The other way activeworkbook.Worksheets(1).Cells(1,1).Id ="100" ?activeworkbook.Worksheets(1).Cells(1,1).Id 100 ?10*activeworkbook.Worksheets(1).Cells(1,1).Id 1000 This retains the type of the value but does have the overhead of remembering where the value is held (there is no variable name!). "Fred Kruger" wrote: Can anyone tell me if excel has an in built variable for each workbook simular to the words Activedocument.Variables("") If so what is it please i cannot seem to find and referance to such a variable. If not does anyone know of a way of storing information in a variable that is specific only to that workbook. Thanks in anticipation. Fred . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Work menu (Word) equivalent in Excel? | Excel Discussion (Misc queries) | |||
Can you convert a number to word equivalent ? | Excel Worksheet Functions | |||
Word equivalent of Excel code | Excel Programming | |||
VBA equivalent vbscript start outlook & word | Excel Programming | |||
Auto Open and Passing variable value(s) to MS Word | Excel Programming |