学习Excel技术,关注微信公众号:excelperfect
标签:VBA如下图1所示,在名为“工作簿1.xlsm”的工作簿的工作表Sheet1中,标题为“StartDate”的列有一系列日期,但其中有很多重复的日期,现在要对其进行筛选,获取不重复日期,示例结果如图1中的列C所示。图1打开VBE,插入一个标准模块,在其中输入代码:Sub GetDates() Const adOpenStatic = 3 Const adLockOptimistic = 3 Const adCmdText = &H1 Dim cn As Object, rs As Object Set cn = CreateObject("ADODB.Connection") Set rs = CreateObject("ADODB.Recordset") cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=" & ThisWorkbook.FullName & ";" & _ "Extended Properties=""Excel 12.0;HDR=Yes;IMEX=1;TypeGuessRows=0;ImportMixedTypes=Text""" rs.Open "SELECT DISTINCT [Sheet1$].[StartDate] FROM [Sheet1$]
………………………………