Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

[b]unprotect excel sheet,write and protect it[/b]

Status
Not open for further replies.
Horowitz

Horowitz

Programmer
Jan 29, 2005
30
GR
Hi, listen to this...
I want to open excel from vb6 and load a sheet.The sheet is protected (Tools -> Protection -> Protect sheet) with the password "Hello". My vb application should open the file (e.g c:\abc.xls) provide the password so i can make some changes, and last protect the sheet with the same password.

Any help will be appreciated...
 
Status
Not open for further replies.

Similar threads

Ken01
  • Locked
  • Question
Areas under graphs and overlap areas between circles. 2
Replies
3
Views
748
Ken01
Ken01
sal21
  • Locked
  • Question
loopimg link and downlosd zip file 1
Replies
3
Views
239
strongm
strongm
wires
  • Locked
  • Question
Install VB6 IDE and Access97 on W11 ARM version 1
Replies
3
Views
414
Gabor526
G
sal21
  • Locked
  • Question
API REST get zip cod efrom street name and city
Replies
1
Views
208
strongm
strongm
Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
389
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top