Re: Extracting data from an XML to put into a constant

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



mr_unreliable wrote:
Bob Barrows [MVP] wrote:
Well, you cannot set a contant's value at runtime: constants can
only be set at compile time,

If one is willing to use the "wsf" construct, then one may
access the constants in an object's typelib by using the
"reference tag".

Here is an example:

--- <code> ---
<job>
<reference object="Excel.***.8" />
<script language="VBScript">
MsgBox("test XL ref. xlTextFormat = " & CStr(xlTextFormat))
</script>
</job>
--- </code> ---

Copy out the code into a file, and name it "testXLConstant.wsf".

Interesting, but I don't understand the relevance. You don't seem to be
talking about setting a constant's value at runtime.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.


Quantcast