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 Mike Lewis 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. tps14334

    Trigger VBScript from ASP webpage

    Alot of trial and error with hunting around for code snippites online lead to this solution: <script> function App_Launch() { if (!document.all) { alert ("Available only with Internet Explorer."); return; } var ws = new...
  2. tps14334

    Renaming uploaded files

    Something here maybe of help: http://classicasp.aspfaq.com/files/directories-fso/can-i-rename-a-file-using-filesystemobject.html
  3. tps14334

    Trigger VBScript from ASP webpage

    I am trying to figure where I am going wrong here. I am looking to have a webpage trigger the code below which tunnels from my web server to my application to then kick off a batch file which calls up a program and begins automation of various functions. Dim WshShell, oExec Set WshShell =...
  4. tps14334

    Extra connectivity to a SQL or MySQL database

    Does anyone have any examples or documentation on getting extra to connect to a SQL or MySQL database, including how to add, update, and move through the records?
  5. tps14334

    Attachmate to Excel, SaveAs the open Workbook

    This worked perfectly, thank you!
  6. tps14334

    Attachmate to Excel, SaveAs the open Workbook

    I have done alittle poking around on here and trying different resources that I know of and still end up with a scripting error when trying to save the open workbook. Here is the code to call the Excel session: Dim xlApp As Object, xlSheet As Object Set xlApp =...
  7. tps14334

    Session Disconnect/Connect

    This issues was resolved by the following code: Sess0.Connected = False Pause(2) Sess0.Connected = True Pause(2)
  8. tps14334

    Disconnect Session

    Could you share the code you use to launch extra, load a session, execute a macro, and how you closed it?
  9. tps14334

    Session Disconnect/Connect

    I tried to search around on Google for several minutes, however I was unable to come up with any useful information. If there a way I could write a script for Extra to have it disconnect from it's session and reconnect again (there is a button in the tool bar I use manually)? Thank you for any...
  10. tps14334

    Multiple Variable PutString from Excel to Attachmate

    A little more poking and brain stretching has now gotten this script, at least this part of it, working. Needed to drop the resize feature/class/command/???? on additional variables for columns other than my control.
  11. tps14334

    Multiple Variable PutString from Excel to Attachmate

    So I've spent a little more time with this trying to figure out how to get it to stage each column as different variables. For some reason I was thinking that the script was running faster than the applications were performing and put in some delays but that failed with the same error (as...
  12. tps14334

    Multiple Variable PutString from Excel to Attachmate

    I took this code (from http://www.tek-tips.com/viewthread.cfm?qid=1505010&page=1) and tried expanding on it to do a-bit more. Here is the code I currently have sans a majority of the variables: Const g_HostSettleTime as integer = 1 Global System As Object,Sess0 As...
  13. tps14334

    GetString - PutString from Excel to Attachmate - response back Excel

    Skip, im hoping you can help me here some. I took this code and tried expanding on it to do a-bit more. Here is the code I currently have sans a majority of the variables: Const g_HostSettleTime as integer = 1 Global System As Object,Sess0 As Object,Sessions As Object,Screen...
  14. tps14334

    GetString - PutString from Excel to Attachmate - response back Excel

    I was looking for something just like this. Thank you, it has been a big help for me as well!
  15. tps14334

    Dynamic variables by record in a Spreadsheet/CSV File

    See the link below for a screen shot of the About window. http://img143.imageshack.us/img143/39/3270terminalyk3.jpg http://img143.imageshack.us/img143/39/3270terminalyk3.jpg
  16. tps14334

    Dynamic variables by record in a Spreadsheet/CSV File

    The 3270 Terminal Emulator is what I have to use to run VBA scripts into our billing system.
  17. tps14334

    Dynamic variables by record in a Spreadsheet/CSV File

    Any information emulator access from Excel?
  18. tps14334

    Dynamic variables by record in a Spreadsheet/CSV File

    So, I am missing something here ... I am going to be running this script in a 3270 Terminal emulator which access a billing system command line to perform specified actions. I am gathering that the scripting engine of the emulator can not comprehend how (or maybe where) to react to a FSO since...
  19. tps14334

    Dynamic variables by record in a Spreadsheet/CSV File

    That looks like it would do the trick, however I still get an error when the file is being mounted Dim fs, objTextFile Set fs = CreateObject("Scripting.FileSystemObject") Dim arrStr Set objTextFile = fs.OpenTextFile("c:\20081209A.csv") Do While Not objTextFile.AtEndOfStream arrStr =...
  20. tps14334

    Dynamic variables by record in a Spreadsheet/CSV File

    So far I have declared there will be variables, mounted the csv file, and turn the array into defined variables. The later two sections of code I actually got from a old post in this forum seen here: http://www.tek-tips.com/viewthread.cfm?qid=1231007&page=1 Here is my current code: Sub Main...

Part and Inventory Search

Back
Top