2 Questions Mostly About Run Program

[Guest Pat]

Question 1 )

 

Can I somehow " input " data into an Excel document using the RUN PROGRAM module ??

 

If so, can it be done using version 2.9 ??

 

 

Question 2 )

 

Is there a way to JOIN 2 or more recordings together

automatically so that there may be 2 or more different persons who made the recordings ?

 

Is it called " CONCATENATION " ??

 

 

Thanks

[SupportTeam]

From VoiceGuide help file (Run VB Script module section):

 

Example 6:

The VB Script below retrieves information from an Excel spreadsheet.

 

Dim xlApp 'Excel.Application

Dim xlBook 'Excel.Workbook

dim xlSht

Dim filename, value1, value2, value3, value4

 

filename = "c:\Warehouse.xls"

 

Set xlApp = CreateObject("Excel.Application")

set xlBook = xlApp.WorkBooks.Open(filename)

set xlSht = xlApp.activesheet

 

value1 = xlSht.Cells(2, 1)

value2 = xlSht.Cells(2, 2)

 

msgbox "Values are: " & value1 & ", " & value2

 

xlBook.Close False

xlApp.Quit

 

Set xlBook = Nothing

Set xlApp = Nothing

 

 

 

Example 7:

The VB Script below saves information to an Excel spreadsheet.

 

Dim xlApp 'Excel.Application

Dim xlBook 'Excel.Workbook

dim xlSht

Dim filename, value1, value2, value3, value4

 

on error resume next

 

filename = "c:\warehouse.xls"

 

Set xlApp = CreateObject("Excel.Application")

set xlBook = xlApp.WorkBooks.Open(filename)

set xlSht = xlApp.activesheet

 

xlApp.DisplayAlerts = False

 

'write data into the spreadsheet

xlSht.Cells(2, 2) = "New Data"

 

xlBook.Save

xlBook.Close SaveChanges=True

xlApp.Close

xlApp.Quit

 

set xlSht = Nothing

Set xlBook = Nothing

Set xlApp = Nothing

 

you cannot do this from v2.9 - that version does not have a "Run VB Script" module.

 

 

To join two sound files:

 

Multiple sound files can be selected to be played by separating the successive files by commas. eg:

 

prompts\1.wav, prompts\2.wav

 

would result in two files from the prompts subdirectory being played (1.wav and 2.wav) one after another.

 

This again only works in v4