Script file on command line ?

I am attempting to use the ApplicationValue() function in a cell formula to obtain a value from a text file specified by a command line parameter as described by the ApplicationValue() function on-line help.

My script file has one variable definition as follows: set BU = “SMMO”

In a report, I am using a cell formula as follows: =ApplicationValue(“BU”)

The cell value remains empty. Can someone see what I am doing wrong?

TIA,

Donald May
MIS Eagle Services
Pratt & Whitney
Ph: (860) 565-5253 Fax: (860) 565-4347 M/S: 117-35
E-mail: maydp@pweh.com


Listserv Archives (BOB member since 2002-06-25)

X-cc: “maydp@pweh.commaydp@pweh.com

Make sure you are declaring this a string

Sub Main()
Dim BU as String

BU = “SMMO”

End Sub

In report:
=ApplicationValue(“BU”)

I use this feature a lot using dates, and it seems to work fine. I don’t use the “set” command in the script, rather just give it the value.

Tim


Tim Heuer
PacifiCare Health Systems
(714) 825-5702 - office
(800) 946-4645 pin 1404017 - pager
heuer_tk@exchange.phs.com


Listserv Archives (BOB member since 2002-06-25)