Article View: free.it.visual-basic
Article #2711aiutino :o)
From: Franco Mario
Date: Fri, 28 Feb 2003 18:07
Date: Fri, 28 Feb 2003 18:07
52 lines
2736 bytes
2736 bytes
Ciao a tutti avrei bisogno di un favore, ho trovato su internet un foglio di
excel per magazzino ed e molto bello, ma mi chiede nome utente e pasword per
cambiare alcune cose, dal codice di visula basic (che io non conosco per
nulla) si puo sapere che nome mettere? il codice e questo
Grazie a tutti
Dim frase(20) As String, a As Integer, pass As String
Private Sub CommandButton1_Click()
On Error Resume Next
Application.EnableCancelKey = xlDisabled
Application.ScreenUpdating = False
pass = TextBox1.Text
a = Len(pass)
Select Case a
Case Is < 6
MsgBox "Nome non valido, immetti almeno sei lettere",
vbExclamation
Exit Sub
Case Is > 10
pass = Mid(pass, 1, 10)
Case Is < 10
pass = pass + "dtlw"
pass = Mid(pass, 1, 10)
End Select
For i = 1 To 10
a = Asc(Mid(pass, i, 1)) + i
If a > 122 Then a = a - 122 + 60
frase(i) = Chr$(a)
Next
If TextBox2 = frase(5) + frase(1) + "/5" + frase(7) + frase(1) +
frase(3) + frase(2) + frase(8) + "3" + frase(4) + "\5" + frase(10) +
frase(9) Then
With Sheets("Copertina")
.Select
.Unprotect ("�=@���[]125.;:448973%&$�~|)0hgdtstYFAJJH")
.Range("e10").Value = True
.Range("e11").Value = TextBox1.Text
End With
Sheets("Copertina").Protect
("�=@���[]125.;:448973%&$�~|)0hgdtstYFAJJH")
Else: MsgBox "Password errata", vbExclamation
End If
Application.ScreenUpdating = True
Unload Me
End Sub
Private Sub CommandButton2_Click()
Unload Me
End Sub
Private Sub TextBox2_Change()
End Sub
Technical Details
Message-ID:
<yzN7a.251403$0v.6984791@news1.tin.it>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!skynet.be!skynet.be!news.mailgate.org!nntp.infostrada.it!news-out.tin.it!news-in.tin.it!news1.tin.it.POSTED!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: f94ee,850395a2b531aa3f,start X-Google-Attributes: gidf94ee,public X-Google-ArrivalTime: 2003-02-28 10:07:27 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!skynet.be!skynet.be!news.mailgate.org!nntp.infostrada.it!news-out.tin.it!news-in.tin.it!news1.tin.it.POSTED!not-for-mail From: "Franco Mario" <ilgrandeblek@tin.it> Newsgroups: free.it.visual-basic Subject: aiutino :o) Lines: 54 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: <yzN7a.251403$0v.6984791@news1.tin.it> Date: Fri, 28 Feb 2003 18:07:26 GMT NNTP-Posting-Host: 62.211.146.45 X-Complaints-To: newsmaster@tin.it X-Trace: news1.tin.it 1046455646 62.211.146.45 (Fri, 28 Feb 2003 19:07:26 MET) NNTP-Posting-Date: Fri, 28 Feb 2003 19:07:26 MET Organization: TIN