Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mattshoreson

    V. New to VBScript!

    or what about defaulting to error on macro entry and then amending to success pre exit sub. Would this capture the runtime?
  2. mattshoreson

    V. New to VBScript!

    I used this as the source for errorlevel values. http://www.rgagnon.com/wshdetails/wsh-0024.html Incorrect?
  3. mattshoreson

    V. New to VBScript!

    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.
  4. mattshoreson

    V. New to VBScript!

    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.
  5. mattshoreson

    V. New to VBScript!

    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...
  6. mattshoreson

    V. New to VBScript!

    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...
  7. mattshoreson

    ASp.net text box not showing in frame

    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.
  8. mattshoreson

    Assigning variable length array to userform combo box list.

    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...

Part and Inventory Search

Back
Top