Dont need to - changed the sub in the macro to a function to return the 0/1 flag.
Can use this flag in the line
e.g. wscript.quit(1)
then the batch can query for %errorlevel%
It's cool - I got it to work, it's clunky, but it works.
It does, that's my original point...
...The error trapping in the macro returns a 1 if error, 0 if not.
I wanted to reutrn this value to the vbs in order to use it in the wscript.quit() line.
The batch file the schduler runs can then query echo %errorlevel% for the flag.
Thanks for your reply.
The vbscript calls the macro and the SP is called from the macro. Calculations and transformations are applied to the data and then returned to a sheet and saved as a csv.
These over-complicated steps are necessary due to the architec at work, limited access to the...
Ok here goes, the basic architecture is as follows:
scheduler has a batch file with looks for an errorlevel of 0 or 1.
Batch file calls a vbs file.
vbs file runs a sql server stored procedure to place a file in a specified directory for subsequent pull of an ftp job.
Code for vbs files is as...
When I create a ASP.net VB page in DMX and add an asp.net textbox then preview in a browser the textbox displays fine.
However, If I put frames on the page and then put the asp.net control in the main area and preview it doesnt show!
Can anyone shed any light on the situation?
Many thanks.
Matt.
I want to set the list of values in a combo box to a the values I have stored in a variable length array.
So far I have:
Assign values to a variable length array....
ReDim myArray(FileCount)
For n = 1 To FileCount
myArray(n) = .FoundFiles(n)
Next n
Assigning array values to combo box...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.