View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Lambson Paul Lambson is offline
external usenet poster
 
Posts: 17
Default .bat file to enter password protected .xls sheet

I am trying to create a .bat file to open a .xls file. But the file is
password protected to modify. I can't figure out the code to enter the
password in the .bat file and then hit the "OK" key

start "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE"
"W:\YIELDMGT\Paul Lambson\SAS\ThanksChart.xls"
nircmd.exe dlg "password" click OK

the first two lines get me to the prompt for the password but i'm
stuck there

HELP~~

Paul