Sign in
Microsoft.com
 
Resources for IT Professionals
 
 
 
Resources for IT Professionals > Forums Home > Windows Academic Forums > Windows Academic: Curriculum > please help
Ask a questionAsk a question
Search Forums:
 

Questionplease help

  • Friday, June 20, 2008 2:25 PMbar_flyz Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    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
     

All Replies

  • Friday, October 10, 2008 2:01 PMDigitalPerson Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    same problem


    ------
    http://ite-sy.net
     
  • Friday, October 24, 2008 12:03 AMSerge Lidin, MSFTOwnerUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    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