-
N-sheets
以G列分成多个工作表(以宏运行VBA)
(Sub aa()
Dim a As Integer, b As Integer, c As Integer, sh As Worksheet
For a = 2 To [g65536].End(3).Row
If Cells(a, 7) <> Cells(a- 1, 7) Then
b = a
End If
c = Range("g:g").Find(Cells(a, 7), , , , , xlPrevious).Row
Set sh = Sheets.Add(, Sheets(Sheets.Count))
sh.Name = Sheets("sheet1").Cells(a, 7).Value
With Sheets("Sheet1")
Sheets("Sheet1").Range(.Cells(b, 1), .Cells(c, 10)).Copy Destination:=sh.[a2]
Sheets("Sheet1").Range("a1:j1").Copy Destination:=sh.[a1]
a = c
End With
Sheets("Sheet1").Select
Next
End Sub
)
- 2013-05-03 08:50:54下载
- 积分:1
-
filter
dbf filter sample I found and very useful for dbf database programing
- 2013-07-24 04:38:03下载
- 积分:1
-
odbc-student
VC++60编译通过,利用ODBC操作*.mdb数据库,非常完善的学生信息管理系统。可以改为其它数据库。(VC++ 60 compiler through the use of ODBC operation*. mdb database, an excellent student information management system. Could be converted to other databases.)
- 2008-07-09 22:29:15下载
- 积分:1
-
iif
Handling null fields in SQL queries
- 2013-09-01 04:27:04下载
- 积分:1
-
sqlite-3_3_7
sqlite-3_3_7 源代码,最稳定的sqlite源码,可以编译成linux、windows、mac等版本(sqlite-3_3_7 源码)
- 2013-11-04 14:13:46下载
- 积分:1
-
DAO
说明: DAO读写(literacy DAO)
- 2005-10-29 23:52:58下载
- 积分:1
-
vb-access
visual basic和access 数据库开发实例 (vb access database)
- 2011-12-06 23:23:11下载
- 积分:1
-
LabVIEW
利用access数据库开发的用户登录界面(User Login System design by LabVIEW)
- 2018-06-16 22:47:44下载
- 积分:1
-
VCDatabaseOpraterADO
说明: VC操作ADO和datagrid控件的源码,是动态的的。不受目录改变的限制(ADO and VC operation datagrid source control is the dynamic. From the directory to change the restrictions)
- 2009-07-30 20:58:21下载
- 积分:1
-
to_connect_excel
说明: 实现如何连接excel(有详细代码 ),采用CSharp语言(The realization of how to connect excel (detailed codes), using CSharp Language)
- 2009-08-11 09:36:44下载
- 积分:1