Is it possible to pass parameter(s) to an excel workbook? Then what is called a workbookparameter?

[prabha_friend]

What is called an excel workbookparameter? If we can change a name into a workbookparamter, can we pass variables to an workbook?

One more question:
I have given a name for a constant.
Constant's Value = 10
Name of the constant = Constant1

But Activeworkbook.names("Constant1").value is giving "=10". What is the effective way to read the constant's value without the "=" on it?

Note:
I am naming a constant because I don't want to allot a cell to hold a value which doesn't actually require a cell to reside.

 

[pgc01]

Hi

If you want the value of the named constant you have to evaluate it

Try:

MsgBox Evaluate("Constant1")

 

[prabha_friend]

Thank you very much pgc. I searched on net about the workbookparameter but not getting a clear idea. Is it possible to parameterize an excel workbook?

 

[prabha_friend]

Hi

If you want the value of the named constant you have to evaluate it

Try:

MsgBox Evaluate("Constant1")

OK. I got how to read the value of a named constant in the right way but how to set it in the right way? Do I have to append an "=" always before that?
while setting workbook.names("Constant1").value = "=" & evaluate("Constant1")+1

?

Thanks to your reply.

 

[pgc01]

Hi

I don't think you have to append the "=". Excel will do it automatically.
Did you test it?