By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,309 Members | 1,452 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,309 IT Pros & Developers. It's quick & easy.

Open a pasword protected excel-sheet

P: n/a
HDI
Hi,

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

Thx

Apr 10 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
in excel.. you type in the password

On Apr 10, 10:40 am, "HDI" <h...@hotmail.comwrote:
Hi,

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

Thx

Apr 10 '07 #2

P: n/a
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


On Apr 10, 10:40 am, "HDI" <h...@hotmail.comwrote:
Hi,

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

Thx

Apr 10 '07 #3

P: n/a
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.
------------------------------
"HDI" <hd***@hotmail.comwrote in message
news:11**********************@b75g2000hsg.googlegr oups.com...
Hi,

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

Thx

Apr 11 '07 #4

P: n/a
On 10 Apr 2007 10:40:39 -0700, "HDI" <hd***@hotmail.comwrote:

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)
Apr 13 '07 #5

P: n/a
bull mother fucking shit

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

fuck you kids

On Apr 10, 11:47 pm, "RobinS" <Rob...@NoSpam.yah.nonewrote:
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.
------------------------------"HDI" <h...@hotmail.comwrote in message

news:11**********************@b75g2000hsg.googlegr oups.com...
Hi,
How can I programmatically open a password protected excel-sheet?
Thx

Apr 20 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.