Open a pasword protected excel-sheet

  • Thread starter Thread starter HDI
  • Start date Start date
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
 
Back
Top