Open a pasword protected excel-sheet

HDI

Hi,

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

Thx

Apr 10 '07 #1

Subscribe Post Reply

5754

Larry Linson

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

Larry Linson

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

RobinS

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

Paul Clement

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

Larry Linson

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

by: Geert-Pieter Hof | last post by:

Hello, My VB 6.0 application read and writes data from and to a MS Excel workbook, using the Microsoft.Jet.OLEDB.4.0 provider. Now I want to protect the Excel workbook with a password, but I...

Visual Basic 4 / 5 / 6

Excel hangs while trying to open a workbook in ASP

by: Lize | last post by:

Hi, I'm writing an ASP application to open an excel workbook, then run a macro stored in the excel file, which produces outputs that will be displayed back onto my ASP application. Now the...

ASP / Active Server Pages

The connection is already Open (state=Open).

by: ST | last post by:

This is my other error when I click on Immunoflourescence. I believe this is related to the other error I just posted (Input string was not in a correct format.) Please let me know if you have...

.NET Framework

how to open a new window with no toolbar after login

by: chirakg21 | last post by:

I have a one single login page with two textbox of Username(txtUsername) and password (txtPassword) and two buttons with one Login(cmdLogin) and Cancel(cmdCancel). Now in the code behind I have...

ASP.NET

Unable to open Excel with macro

by: guptasourav | last post by:

I am opening an Excel file on my server, and saving it with some other name and then trying to coping the new excel to my local machine. If i use a simple Excel(without macro but with password) it...

.NET Framework

Excel 2003 cannot open Output file

by: Fendi Baba | last post by:

I created an ASP.net page which opens excel. This works fine in Office 2007. However, Excel 2003 runs in an error which states "cannot read output file". Hee is the VB code and below is the ASPX...

ASP.NET

Win32::OLE open excel file as read only

by: momukhtar | last post by:

I am using Win32::OLE to write a perl script which opens an excel file. That excel file is password protected and everytime i run that script dialog box pops up and I have to click on Read-Only then...

Perl

XLS DataSet to Excel will not open unless saved

by: ShadowLocke | last post by:

I have code that uses an XSL stylesheet to transform a dataset into a file that MS Excel can read. Below is a simplified version of the code. This works..for the most part. It sucessfully sends the...

ASP / Active Server Pages

open password protected excel file using vb.net

by: veer | last post by:

Hi i want to open excel file using vb.net . The file is passsword protected and i know the password when i used to open the file with out password it works fine and open but when the file with...

.NET Framework

Open Excel file as read only

by: Mel | last post by:

How do I open an Excel file as a read only document? It would be okay if it opened in the browser window but I don't want the user to save any changes and stomp over my original file on the...

ASP.NET

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Open a pasword protected excel-sheet

Similar topics