INS support forum    


Welcome to the Integrated Notification System support forum.
Before entering a query/request please search the forum to see if someone else has asked the question before.
Please feel also free to respond to queries from other users if you have experienced the same type of problem and found a solution to it. 
Our support team will monitor this forum and endeavour to provide answers to the queries posted.
Please make sure to post your query to the right forum as there is a separate forum for each application provided by MAW Software.
Show messages for: Last 7 days Last 30 days All (Digest of all)

Back to the forum

On Monday , the 10.18.2004, John wrote at 21:55:09 :

ActiveX help needed

ok....with your suggestion I started looking into using ActiveX for getting the data we need. I set up an Excel spreadsheet to get DDE info from Citect (that does work). Then I used your ActiveX with Excel demo to write a small test program. However, the return value never gets returned.

My VBS code is as follows.....
Dim xlfile
Dim ID

Set xlfile = GetObject(, "Excel.Application")
ID = xlfile.Range("B3").Value
msgbox(ID) ' to test if the value is being read from Excel correctly
WScript.Quit(ID)


The value in the cell DOES read back correctly to set ID, but it appears that the Wscript.Quit(ID) doesn't function as it does with your example.....either a zero length string or nothing is returned.

I set up the Run VBS code module with a checkmark in the Wait Until Complete checkbox and destinations for the success and fail options. (success goes to a speak string module and fail goes to a hang up module). The "string" to speak in the speak string module is $RV[New Module[1]]. I left the default namings when I made the script.

The Run VBS code module is 1, speak string is 2 and hang up is 3.

I know you said you were going to set up a computer with XP-SP2 to test with. Have you had a chance and what were your results? It is not an option to use anything other than XP-SP2 at my work as all the computers are currently migrating to that platform.

I made sure that the values stored in the spreadsheet were integers (instead of strings or real numbers) as the Wscript.Quit argument is supposed to return an integer.

Any help is greatly appreciated!



[2004/10/18 14:32:07.376] Message Server Communication Suite 5.5.4 (Single line)
[2004/10/18 14:32:07.376] Registered to tmiller@xenotechllc.com
[2004/10/18 14:32:07.376] Running on WINNT(5.1)
[2004/10/18 14:32:07.485] [Fax Channel] Opening Fax Channel
[2004/10/18 14:32:08.501] [Fax Channel] Command {AT,OK,,,ERROR,5000}
[2004/10/18 14:32:08.579] [Fax Channel] OK
[2004/10/18 14:32:08.720] [Fax Channel] Command {AT+FCLASS=1,OK,,,ERROR,5000}
[2004/10/18 14:32:09.063] [Fax Channel] OK
[2004/10/18 14:32:09.204] [Fax Channel] Command {AT+FCLASS=0,OK,,,ERROR,5000}
[2004/10/18 14:32:09.548] [Fax Channel] OK
[2004/10/18 14:32:10.313] [Pager Channel] Opening Pager Channel
[2004/10/18 14:32:10.313] [Voice Channel] Opening Voice Channel
[2004/10/18 14:32:10.407] [SMS Channel] Opening SMS Channel
[2004/10/18 14:32:10.407] [SMS Channel] SMS Channel is disabled
[2004/10/18 14:32:10.407] [E-Mail Channel] Opening E-mail Channel
[2004/10/18 14:32:10.407] [E-Mail Channel] E-mail Channel is disabled
[2004/10/18 14:32:10.407] [Timer Channel] Opening Timer Channel
[2004/10/18 14:32:10.407] [Timer Channel] Timer Channel is disabled
[2004/10/18 14:32:11.454] [Out Channel] Scanning new messages...
[2004/10/18 14:32:22.453] [Out Channel] Scanning new messages...
[2004/10/18 14:32:22.469] Launched message ID=20041018143212000 by Voice (preselected)
[2004/10/18 14:32:22.594] [Voice Channel] Init device for voice Analog Line 1(dxxxB1C1)
[2004/10/18 14:32:22.625] [Voice Channel] DIAL 2277149
[2004/10/18 14:32:35.827] [Voice Channel] Current module : EnterKeys
[2004/10/18 14:32:35.827] [Voice Channel] Playing file C:\MsgServer\SampleScripts\VoiceScripts\ActiveX with Excel\EnterKeys.WAV
[2004/10/18 14:32:39.358] [Voice Channel] Playing file C:\MsgServer\Assorted\BEEP.WAV
[2004/10/18 14:32:40.826] [Voice Channel] DTMF(9)
[2004/10/18 14:32:41.108] [Voice Channel] DTMF(0)
[2004/10/18 14:32:42.326] [Voice Channel] DTMF(2)
[2004/10/18 14:32:42.608] [Voice Channel] DTMF(1)
[2004/10/18 14:32:43.123] [Voice Channel] DTMF(0)
[2004/10/18 14:32:43.217] [Voice Channel] Current module : AddToExcel
[2004/10/18 14:32:43.217] [Voice Channel] Evaluated $RV[@TIME] to 14h32m43s
[2004/10/18 14:32:43.217] [Voice Channel] Evaluated $RV[@CID] to 0000
[2004/10/18 14:32:43.217] [Voice Channel] Evaluated $RV[EnterKeys] to 90210
[2004/10/18 14:32:43.967] [Voice Channel] Current module : Confirmation
[2004/10/18 14:32:43.967] [Voice Channel] Evaluated $RV[@ScriptDir] to C:\MsgServer\SampleScripts\VoiceScripts\ActiveX with Excel
[2004/10/18 14:32:43.967] [Voice Channel] Playing file C:\MsgServer\SampleScripts\VoiceScripts\ActiveX with Excel\Confirmation.WAV
[2004/10/18 14:32:47.841] [Voice Channel] Current module : ReturnID
[2004/10/18 14:32:47.841] [Voice Channel] Evaluated $RV[AddToExcel] to 8
[2004/10/18 14:32:47.841] [Voice Channel] Playing file C:\MsgServer\Assorted\I.WAV
[2004/10/18 14:32:48.779] [Voice Channel] Playing file C:\MsgServer\Assorted\D.WAV
[2004/10/18 14:32:49.404] [Voice Channel] Playing file C:\MsgServer\Assorted\EQUAL.WAV
[2004/10/18 14:32:51.279] [Voice Channel] Playing file C:\MsgServer\Assorted\8.WAV
[2004/10/18 14:32:52.029] [Voice Channel] Current module : Hangup
[2004/10/18 14:32:52.029] [Voice Channel] End of script, hanging up
[2004/10/18 14:32:52.263] [Voice Channel] Call is disconnected
[2004/10/18 14:32:52.575] [Voice Channel] Call is disconnected
[2004/10/18 14:32:58.450] [Out Channel] Scanning new messages...
[2004/10/18 14:33:09.449] [Out Channel] Scanning new messages...
[2004/10/18 14:33:20.448] [Out Channel] Scanning new messages...
[2004/10/18 14:33:31.447] [Out Channel] Scanning new messages...
[2004/10/18 14:33:42.446] [Out Channel] Scanning new messages...
[2004/10/18 14:33:46.446] [Out Channel] Scanning new messages...
[2004/10/18 14:33:46.446] Launched message ID=20041018143337000 by Voice (preselected)
[2004/10/18 14:33:46.587] [Voice Channel] Init device for voice Analog Line 1(dxxxB1C1)
[2004/10/18 14:33:46.618] [Voice Channel] DIAL 2277149
[2004/10/18 14:34:01.835] [Voice Channel] Current module : New Module[1]
[2004/10/18 14:34:04.210] [Voice Channel] Current module : New Module[2]
[2004/10/18 14:34:04.210] [Voice Channel] Evaluated $RV[New Module[1] to
[2004/10/18 14:34:04.335] [Voice Channel] Current module : New Module[3]
[2004/10/18 14:34:04.335] [Voice Channel] End of script, hanging up
[2004/10/18 14:34:04.569] [Voice Channel] Call is disconnected
[2004/10/18 14:34:04.882] [Voice Channel] Call is disconnected
[2004/10/18 14:34:09.444] [Out Channel] Scanning new messages...





Post reply:

Name:
E-Mail:
Subject:
Message:
SPAM code displayed
next to this:

CGIForum (C) Markus Triska

Home to