473,322 Members | 1,562 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

open password protected excel file using vb.net

198 100+
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 password protected file came it shows the error "File can't be decrypt"

sconnectionstring ="Provider=Microsoft.jet.oledb.4.0;data source=c:\new.xls;Extended Properties=excel8.0;

please tell me how can i open the password protected excel file

best regards
varinder
Aug 8 '08 #1
2 5241
Curtis Rutland
3,256 Expert 2GB
According to connectionstrings.com it can't be done with ole. Maybe you can do it with ODBC, or perhaps there is a way with Interop.
Aug 8 '08 #2
Hey Buddy,

I dont know how to open an excel file using connection string, But if you want I can tell you how to open a password protected file using COM wrapper,

Means using Excel object..

If you require this please let me know..

ATishRG
Aug 12 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

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...
3
by: | last post by:
I am writing a small program that needs to be able to open Excel workbooks which are password protected. Does anyone know how to do this, without any interaction from the user? I am sure it is...
4
by: kthiagar | last post by:
Hi I am trying to connect to a password protected access file from VB.NET. I have no problem in connecting to Access, if I remove the password. This is what I am doing: In the server explorer,...
4
by: connoisseur.infotech | last post by:
hello we are developing one tool where we need to open and make password protected zip files. we found some solutions but they don't support password protected things. does any one knows about...
1
by: dbanker | last post by:
Hey all, I am trying to use VB in an Access module to open a specific Excel file. Can anyone help me?
2
by: shmsrisampath | last post by:
how to open password protected access file from vb 6.
1
by: Muslim | last post by:
I have a VB program that reads an Excel file and inserts the rows into a database. Problem is in some installations it works fine but in others it will only work if I remove the workbook password....
1
by: mohanprasadgutta | last post by:
Hi, I need help to open a password protected excel file in perl using Win32:OLE. when I tried to open file in normal way at the time of program execution it is prompting me to enter password. I am...
4
Heather Thurber
by: Heather Thurber | last post by:
I am using the following code in Access 2007 to open an excel spreadsheet when as part of an on click function: Dim objXLApp As Object Dim objXLBook As Object Set objXLApp =...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.