Open a pasword protected excel-sheet

  • Thread starter Thread starter HDI
  • Start date Start date
H

HDI

Hi,

How can I programmatically open a password protected excel-sheet?

Thx
 
you can remove the password programmatically right?


record a macro, remove the password.. then look at the macro

I'd reccomend using Excel VBA; since this .net crap doesn't support
office yet
 
Try posting your question to an Excel programming newsgroup.
Oh, and FYI, that Larry Linson guy is trolling. Be very wary about
believing anything he says.
Robin S.
 
¤ Hi,
¤
¤ How can I programmatically open a password protected excel-sheet?

You need to supply a bit more information. Are you opening it via data access? Automation?

Assuming it's via automation the Workbooks collection Open method has a Password parameter that you
can specify when opening a Workbook file.


Paul
~~~~
Microsoft MVP (Visual Basic)
 
bull mother ****ing shit

i'm not a troll.. i'm just the only one with BALLS around here

**** you kids
 
You must log in or register to reply here.

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Copying in sheet with protection with the use of a macro 5
Open file password 13
Excel Excel spreadsheets opening at top instead of bottom. 4
Unprotect sheets, how to? 10
Open password protected file with macros 2
Excel Excel macro and passwords 3
Excel, assign cells in multiple worksheets from one sheet 1

Back
Top