{"id":234,"date":"2024-01-31T14:09:40","date_gmt":"2024-01-31T06:09:40","guid":{"rendered":"https:\/\/blog.ecomine.tech\/?p=234"},"modified":"2024-02-20T17:27:57","modified_gmt":"2024-02-20T09:27:57","slug":"%ef%bc%88%e8%bd%ac%ef%bc%89%e7%a0%b4%e8%a7%a3excel%e7%9a%84vba%e5%b7%a5%e7%a8%8b%e4%bf%9d%e6%8a%a4%e5%af%86%e7%a0%81","status":"publish","type":"post","link":"https:\/\/blog.ecomine.tech\/?p=234","title":{"rendered":"(\u8f6c)\u7834\u89e3excel\u7684vba\u5de5\u7a0b\u4fdd\u62a4\u5bc6\u7801"},"content":{"rendered":"\n<p>\u539f\u6587\u94fe\u63a5\u89c1<a href=\"https:\/\/www.jianshu.com\/p\/4dd719bcbf55\">\u7834\u89e3excel\u7684vba\u5de5\u7a0b\u4fdd\u62a4\u5bc6\u7801 &#8211; \u7b80\u4e66 (jianshu.com)<\/a><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Sub MoveProtect()\r\n    Dim FileName As String\r\n    FileName = Application.GetOpenFilename(\"Excel\u6587\u4ef6\uff08*.xls &amp; *.xla\uff09,*.xls;*.xla\", , \"VBA\u7834\u89e3\")\r\n    If FileName = CStr(False) Then\r\n       Exit Sub\r\n    Else\r\n       VBAPassword FileName, False\r\n    End If\r\nEnd Sub\r\n\r\n'\u8bbe\u7f6eVBA\u7f16\u7801\u4fdd\u62a4\r\nSub SetProtect()\r\n    Dim FileName As String\r\n    FileName = Application.GetOpenFilename(\"Excel\u6587\u4ef6\uff08*.xls &amp; *.xla\uff09,*.xls;*.xla\", , \"VBA\u7834\u89e3\")\r\n    If FileName = CStr(False) Then\r\n       Exit Sub\r\n    Else\r\n       VBAPassword FileName, True\r\n    End If\r\nEnd Sub\r\n\r\nPrivate Function VBAPassword(FileName As String, Optional Protect As Boolean = False)\r\n      If Dir(FileName) = \"\" Then\r\n         Exit Function\r\n      Else\r\n         FileCopy FileName, FileName &amp; \".bak\"\r\n      End If\r\n\r\n      Dim GetData As String * 5\r\n      Open FileName For Binary As #1\r\n      Dim CMGs As Long\r\n      Dim DPBo As Long\r\n      For i = 1 To LOF(1)\r\n          Get #1, i, GetData\r\n          If GetData = \"CMG=\"\"\" Then CMGs = i\r\n          If GetData = \"&#091;Host\" Then DPBo = i - 2: Exit For\r\n      Next\r\n      If CMGs = 0 Then\r\n         MsgBox \"\u8bf7\u5148\u5bf9VBA\u7f16\u7801\u8bbe\u7f6e\u4e00\u4e2a\u4fdd\u62a4\u5bc6\u7801...\", 32, \"\u63d0\u793a\"\r\n         Exit Function\r\n      End If\r\n      If Protect = False Then\r\n         Dim St As String * 2\r\n         Dim s20 As String * 1\r\n         '\u53d6\u5f97\u4e00\u4e2a0D0A\u5341\u516d\u8fdb\u5236\u5b57\u4e32\r\n         Get #1, CMGs - 2, St\r\n         '\u53d6\u5f97\u4e00\u4e2a20\u5341\u516d\u5236\u5b57\u4e32\r\n         Get #1, DPBo + 16, s20\r\n         '\u66ff\u6362\u52a0\u5bc6\u90e8\u4efd\u673a\u7801\r\n         For i = CMGs To DPBo Step 2\r\n             Put #1, i, St\r\n         Next\r\n         '\u52a0\u5165\u4e0d\u914d\u5bf9\u7b26\u53f7\r\n         If (DPBo - CMGs) Mod 2 &lt;&gt; 0 Then\r\n            Put #1, DPBo + 1, s20\r\n         End If\r\n         MsgBox \"\u6587\u4ef6\u89e3\u5bc6\u6210\u529f......\", 32, \"\u63d0\u793a\"\r\n      Else\r\n         Dim MMs As String * 5\r\n         MMs = \"DPB=\"\"\"\r\n         Put #1, CMGs, MMs\r\n         MsgBox \"\u5bf9\u6587\u4ef6\u7279\u6b8a\u52a0\u5bc6\u6210\u529f......\", 32, \"\u63d0\u793a\"\r\n      End If\r\n      Close #1\r\nEnd Function\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u539f\u6587\u94fe\u63a5\u89c1\u7834\u89e3excel\u7684vba\u5de5\u7a0b\u4fdd\u62a4\u5bc6\u7801 &#8211; \u7b80\u4e66 (jianshu.com)<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"single-with-sidebar","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-234","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.ecomine.tech\/index.php?rest_route=\/wp\/v2\/posts\/234","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ecomine.tech\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ecomine.tech\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ecomine.tech\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ecomine.tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=234"}],"version-history":[{"count":2,"href":"https:\/\/blog.ecomine.tech\/index.php?rest_route=\/wp\/v2\/posts\/234\/revisions"}],"predecessor-version":[{"id":247,"href":"https:\/\/blog.ecomine.tech\/index.php?rest_route=\/wp\/v2\/posts\/234\/revisions\/247"}],"wp:attachment":[{"href":"https:\/\/blog.ecomine.tech\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ecomine.tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ecomine.tech\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}