M的部落格

ASDASD

--====================== 不常用SQL語法======================--

<script src="https://gist.github.com/michaelctwk/11d75bf00b5c2bd08b78.js"></script>

1、查找重複內容公式：

     =IF(COUNTIF(A:A,A2)>1,"重複","")。

<script src="https://gist.github.com/michaelctwk/7fb4620e5acd5e803ad0.js"></script>

Imports System.Data

Imports System.Net.Mail

'連線錯誤訊息

[Login Failed.  Check for valid user ID, server name and password  Native Error code: 4002]

------------------------------[VBA程式碼]---------------------------------

Private Declare Function GetPrivateProfileString Lib "kernel32" Alias "GetPrivateProfileStringA" (ByVal lpApplicationName As String, ByVal lpKeyName As Any, ByVal lpDefault As String, ByVal lpReturnedString As String, ByVal nSize As Long, ByVal lpFileName As String) As Long

'找尋目前檔案路徑

Dim FullPath As Object