Sub GenData() With Sheet1 .[A1].Value = "ssd" .[B1].Value = "sdfa" .[C1].Value = "sfa" .[A…
h=GetModuleHandle(0) hIcon=LoadIcon(h,129) hCursor=LoadCursor(0,35512) c=PStr("MyClass") p…
'数据库表行数函数,这是取表的行数 Function GetTblRows(TblName) '如果TblName表名值为空,则 if TblName="" Then GetTbl…
Sub print() for i= range("k6") to range("k7") range("m3")=i activeSheet.printout next i En…
using ValidationMessage.Controls; namespace ValidationMessage { public class BasePage : Sy…
Option Explicit Private Const BIF_STATUSTEXT = &H4& Private Const BIF_RETURNONLYFS…
'VB 实现大文件的分割与合并,引用 ADODB.Stream 提供一个过程: '要引用 Microsoft ActiveX Data Objects 2.5 Libary '或 …
Sub CopyChartsIntoPowerPoint() ''' COPY SELECTED EXCEL CHARTS INTO POWERPOINT ' Set a VBE …
'算天数小时函数 function diffuudate(logdate) if datediff("n",logdate,now())<60 then diffuudate…
using System; using System.Collections.Generic; using System.Linq; using System.Web; using…
Option Explicit Function IsMatch(Str, Patrn) Dim r Set r = new RegExp r.Pattern = Patrn Is…
VBA将Excel数据表格直接导入SQL Server数据库