none
please help

    Question

  • I have a batch file as follows:

    G:
    start passwords.xls

    I want to be able to pass the password to this Excel file upon opening it in Excel.

    I have searched Google for an hour with no luck.

    thanks
    Friday, June 20, 2008 2:25 PM

All replies

  • same problem


    ------
    http://ite-sy.net
    Friday, October 10, 2008 2:01 PM
  • In short: you can't do that.

    Longer explanation: Excel doesn't have the command line option to specify password for a protected file. If it had, you could change your batch file to "C:\Program Files\Microsoft Office\OFFICE12\excel.exe" /w "MyPassword" MyFile.xlsx

    But it hasn't (see http://office.microsoft.com/en-us/excel/HA101580301033.aspx).

     

    Also you may want to post such questions on Office-related forums, I'm sure you'd get the answers much more promptly. This forum is about Windows Academic Curriculum.

     

    Thanks,

    Serge

     

    Friday, October 24, 2008 12:03 AM
    Owner