-
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
-
miniSQL
MiniSQL的大致架构在里面了,可以自己填写里面的模块。。(MiniSQL the general framework in which, you can fill out inside the module. .)
- 2011-10-14 22:39:17下载
- 积分:1
-
VCPP-ADO-ACCESS--
能够连接access 数据库和C++原代码,使用ado方式(Able to connect access database and C++ original code)
- 2013-06-19 20:39:41下载
- 积分:1
-
lending-Form
A very simple VB Source that can read / write from access database to Grid
- 2013-02-24 07:45:01下载
- 积分:1
-
DAO
说明: DAO读写(literacy DAO)
- 2005-10-29 23:52:58下载
- 积分: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
-
VCAccess
此demo包含vc操作Access数据库的链接、以及增删改查的基本操作,均提供的有接口,方便用户操作,并且提供了一些模糊查询语句供用户参考~~(This demo contains the Access database, the link vc operations, as well as additions or deletions to change the basic operation of search are provided with interfaces, user-friendly operation, and provides a number of fuzzy query for the user' s reference ~ ~)
- 2010-02-24 13:51:31下载
- 积分:1
-
SetAccessData
对已经存在的Accsess数据库表添加新字段并复值(right Accsess already existing database table and add a new field of Complex)
- 2006-08-10 21:15:31下载
- 积分:1
-
vb-access
visual basic和access 数据库开发实例 (vb access database)
- 2011-12-06 23:23:11下载
- 积分:1
-
EXCELtoMDB
VisualBasic实现EXCEL数据的批量导入,(EXCEL data batch import to mdb based on VB)
- 2012-05-07 21:40:29下载
- 积分:1