For Programmers: Free Programming Magazines  


Home > Archive > Visual Basic > November 2006 > VBScript to open password protected excel file









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author VBScript to open password protected excel file
camanjarresv

2006-11-15, 10:24 am

Hi, I am new at VBScript, but I have some experience with Visual Basic 6. I had written a VBS to open an excel workbook that is protected with open password, but it is not working, Can somebody help me? thanks a lot.

'----
xlApp.Visible = True
xlApp.UserControl = True

xlApp.Workbooks.Open "C:\myfile.xls", Password:="myfile", ReadOnly:=True
'---
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com