-
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
-
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
-
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
-
Population
c++ 链接access 建立的一个小型人员统计系统管理 代码简单(c++ link access to the set of a small staff Biejiao simple statistical system management code)
- 2014-03-09 10:11:57下载
- 积分:1
-
EXCELtoMDB
VisualBasic实现EXCEL数据的批量导入,(EXCEL data batch import to mdb based on VB)
- 2012-05-07 21:40:29下载
- 积分:1
-
ADO
这是ACCESS的数据库编程文件,可以容易的用在MFC,VC,DELPH等工程环境(ACCESS ADO DATABASE ,MFC VS2008 AND VS2010)
- 2013-08-18 10:30:52下载
- 积分:1
-
DAO
说明: DAO读写(literacy DAO)
- 2005-10-29 23:52:58下载
- 积分:1
-
SQLite3Develop
Sqlite3 的确很好用。小巧、速度快。但是因为非微软的产品,帮助文档总觉得不够。这
些天再次研究它,又有一些收获,这里把我对 sqlite3 的研究列出来,以备忘记。(Sqlite3 really good use. Small, fast. But for the Microsoft products, always feel that not enough to help document. This
Some day to study it, and have some harvest, here I study on SQLite3 list, to forget.)
- 2012-09-25 17:13:03下载
- 积分:1
-
tuishuiguanli
VB编写的退税管理系统,可做毕业设计参考,很适用!(VB prepared the tax rebate management system, can be graduated from the reference design, it is applicable!)
- 2008-12-29 16:20:26下载
- 积分:1
-
VS2008和Access的数据库连接及操作完整示例
连接access数据库实例,简单的操作access数据库(Connecting access database instance)
- 2018-08-13 10:14:55下载
- 积分:1