locked
Excel VBscript RRS feed

  • Question

  • Hello everyone,
     
    I'm in dire need for a vbscript script that will make my job alot easier and any help is very much appreciated. The function of the script must do the following:
     
    1. when the script is executed it will prompt for the user to input some data
    2 . modify an existing excel spreadsheet (CSV format) and insert a new row at the very top and shift existing data down one level.
    3.  add the value the user input in the very first cell (A1) and add predefined values in B1, C1, D1, E1, F1, G1, H1, I1, and J1.
    4. Save the close the file.
     
    For example:
                    A                  B          C         D         E          F          G          H          I            J
    1 |  User input data | test1 | test2 | test3 | test4 | test5 | test 6 | test 7 | test 8 | test 9
     
      Thanks in advance!
    • Moved by Bill_Stewart Sunday, November 2, 2014 7:59 PM This is not "scripts on demand"
    Wednesday, September 10, 2014 5:20 AM

All replies