Results 1 to 2 of 2

Thread: Help.. Please

  1. #1
    Join Date
    Sep 2004
    Posts
    2

    Angry Unanswered: Help.. Please

    If a form is created, and when an input is given, I would like it to be saved in for example A.txt, and this A.txt input will then be automatically send to excel macro and run the application, which has been written in vbscript.
    Can we do that?

    Thanks.
    I'm terribly confused

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    in theory I would say yes.... in theory... you would probably want to avoid it like the plague.... you would need Excel installed on the server.

    Anyhow, something like this flow should work

    Save the data using the Scripting.FileSystemObject.

    Open excel using the MS Excel objects that get installed with Excel.

    Set a value in your spread sheet that has a reference to the file. Have the excel macro open the file and use the value....

    Seriously though, I would really avoid doing this. There has to be a better way.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •