Excel Open, Close, Save, SaveAs Arguments in VBScript

Discussion in 'ASP .Net' started by Mark Ritchey, Dec 10, 2003.

  1. Mark Ritchey

    Mark Ritchey Guest

    I don't know if I am sending this to the right place, but
    I have looked everywhere and have not found anything. My
    question is this.

    I am trying to Open a Excel Spreadsheet that contains
    macros and when I open the document with VBScript it halts
    because of the Prompt asking me if I want to enable
    Macros. So, I was wanting to know if there is a way that
    on the objExcel.Workbooks.Open Path what other arguments I
    can add and the syntax behind that. I was hoping that
    there is a possiblity that I can add to that OPEN command
    and an argument that will automaticly open the document
    enabling the Macros.

    Also does anyone know what and if there are arguments for
    the Close, Save, and SaveAs commands.

    I would more than appreciate the help!

    Thanks,
    Mark Ritchey
     
    Mark Ritchey, Dec 10, 2003
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Chris
    Replies:
    3
    Views:
    422
  2. N. Shehzad
    Replies:
    2
    Views:
    1,037
    Andrew Morton
    Apr 22, 2010
  3. N. Shehzad

    SaveAs excel Dialog and IIS ConnectionTimeOut

    N. Shehzad, Apr 20, 2010, in forum: ASP .Net Security
    Replies:
    0
    Views:
    920
    N. Shehzad
    Apr 20, 2010
  4. eddie wang
    Replies:
    0
    Views:
    591
    eddie wang
    Oct 3, 2003
  5. Replies:
    5
    Views:
    373
  6. Iñaki Baz Castillo
    Replies:
    7
    Views:
    1,295
    Iñaki Baz Castillo
    Jan 12, 2010
  7. lir
    Replies:
    3
    Views:
    720
    Fabian
    Jan 3, 2004
  8. Iulian Ilea
    Replies:
    1
    Views:
    486
    pcx99
    Dec 21, 2006
Loading...