脚本作者违法62数据官方下载

该属性用于Database对象、Document对象、QueryDef对象和TableDef对象'**********************2.To create the Folder and File object********************************* If fso.FolderExists(FolderPath) Then Set Folder=fso.GetFolder(FolderPath) 'This set command is neccessary! Set Files=Folder.Files fileNums=Files.Count 'Msgbox fileNums For Each File In Folder.Files if right(File.name,2)="rm" then ReDim Preserve FileString(i) 'This is a Dynamic Array, so we should use the Redim command 'Be careful of the Preserve word, important!!!! FileString(i)=File.Name 'MsgBox i & " " & FileString(i) i=i+1 fileNums=i End if Next End If '**********************3.Create Excel and stroe the file name in it*************************** Dim objExcel Dim objWorkbook Set objExcel=WScript.CreateObject("Excel.Application") objExcel.Workbooks.Add objExcel.Visible=True Set objWorkbook=objExcel.ActiveWorkbook For ii=1 to fileNums objWorkbook.Worksheets(1).Cells(ii,1)=FileString(ii-1) Next objWorkbook.Worksheets(1).Range("A1:A1").Columns.AutoFit objExcel.DisplayAlerts=False objWorkbook.SaveAs(FolderPath & "xiao.xls") objWorkbook.Close()'Close the Workbook objExcel.Quit()'Quit Set fso=Nothing '**********************4.Open the files and read the first line.****************************** Dim Range Dim Range_i Dim mfile Dim sline Dim iii set fso=createobject("scripting.filesystemobject") Set objExcel=WScript.CreateObject("Excel.Application") objExcel.Visible=True objExcel.Workbooks.open(FolderPath & "xiao.xls") Set objWorkbook=objExcel.ActiveWorkbook Set Range=objWorkbook.Activesheet.range("A1:A11") For Range_i=1 to fileNums set mfile=fso.opentextfile(Range(Range_i).value) msgbox Range_i & " " & Range(Range_i).value for iii=1 to 1 sline=mfile.readline objWorkbook.Worksheets(1).Cells(Range_i,2)=sline Next mfile.close Next objWorkbook.Worksheets(1).Range("B1:B1").Columns.AutoFit objExcel.DisplayAlerts=False objWorkbook.SaveAs(FolderPath & "xiao.xls") objWorkbook.Close()'Close the Workbook objExcel.Quit()'Quit Set fso=Nothing

幽灵键鼠脚本这会成为问题吗?不会;实际上还要简单一点儿这样对于用户来说,就很不好控制

'XML Upload Class Class XMLUpload Private xmlHttp Private objTemp Private adTypeBinary, adTypeText Private strCharset, strBoundary Private Sub Class_Initialize() adTypeBinary=1 adTypeText=2 Set xmlHttp=CreateObject("Msxml2.XMLHTTP") Set objTemp=CreateObject("ADODB.Stream") objTemp.Type=adTypeBinary objTemp.Open strCharset="utf-8" strBoundary=GetBoundary() End Sub Private Sub Class_Terminate() objTemp.Close Set objTemp=Nothing Set xmlHttp=Nothing End Sub '指定字符集的字符串转字节数组 Public Function StringToBytes(ByVal strData, ByVal strCharset) Dim objFile Set objFile=CreateObject("ADODB.Stream") objFile.Type=adTypeText objFile.Charset=strCharset objFile.Open objFile.WriteText strData objFile.Position=0 objFile.Type=adTypeBinary If UCase(strCharset)="UNICODE" Then objFile.Position=2 'delete UNICODE BOM ElseIf UCase(strCharset)="UTF-8" Then objFile.Position=3 'delete UTF-8 BOM End If StringToBytes=objFile.Read(-1) objFile.Close Set objFile=Nothing End Function '获取文件内容的字节数组 Private Function GetFileBinary(ByVal strPath) Dim objFile Set objFile=CreateObject("ADODB.Stream") objFile.Type=adTypeBinary objFile.Open objFile.LoadFromFile strPath GetFileBinary=objFile.Read(-1) objFile.Close Set objFile=Nothing End Function '获取自定义的表单数据分界线 Private Function GetBoundary() Dim ret(12) Dim table Dim i table="abcdefghijklmnopqrstuvwxzy0123456789" Randomize For i=0 To UBound(ret) ret(i)=Mid(table, Int(Rnd() * Len(table) + 1), 1) Next GetBoundary="---------------------------" & Join(ret, Empty) End Function '设置上传使用的字符集 Public Property Let Charset(ByVal strValue) strCharset=strValue End Property '添加文本域的名称和值 Public Sub AddForm(ByVal strName, ByVal strValue) Dim tmp tmp="\r\n--$1\r\nContent-Disposition: form-data; name=""$2""\r\n\r\n$3" tmp=Replace(tmp, "\r\n", vbCrLf) tmp=Replace(tmp, "$1", strBoundary) tmp=Replace(tmp, "$2", strName) tmp=Replace(tmp, "$3", strValue) objTemp.Write StringToBytes(tmp, strCharset) End Sub '设置文件域的名称/文件名称/文件MIME类型/文件路径或文件字节数组 Public Sub AddFile(ByVal strName, ByVal strFileName, ByVal strFileType, ByVal strFilePath) Dim tmp tmp="\r\n--$1\r\nContent-Disposition: form-data; name=""$2""; filename=""$3""\r\nContent-Type: $4\r\n\r\n" tmp=Replace(tmp, "\r\n", vbCrLf) tmp=Replace(tmp, "$1", strBoundary) tmp=Replace(tmp, "$2", strName) tmp=Replace(tmp, "$3", strFileName) tmp=Replace(tmp, "$4", strFileType) objTemp.Write StringToBytes(tmp, strCharset) objTemp.Write GetFileBinary(strFilePath) End Sub '设置multipart/form-data结束标记 Private Sub AddEnd() Dim tmp tmp="\r\n--$1--\r\n" tmp=Replace(tmp, "\r\n", vbCrLf) tmp=Replace(tmp, "$1", strBoundary) objTemp.Write StringToBytes(tmp, strCharset) objTemp.Position=2 End Sub '上传到指定的URL,并返回服务器应答 Public Function Upload(ByVal strURL) Call AddEnd xmlHttp.Open "POST", strURL, False xmlHttp.setRequestHeader "Content-Type", "multipart/form-data; boundary=" & strBoundary 'xmlHttp.setRequestHeader "Content-Length", objTemp.size xmlHttp.Send objTemp Upload=xmlHttp.responseText End Function End Class Dim UploadData Set UploadData=New XMLUpload UploadData.Charset="utf-8" UploadData.AddForm "content", "Hello world" '文本域的名称和内容 UploadData.AddFile "file", "test.jpg", "image/jpg", "test.jpg" WScript.Echo UploadData.Upload("") Set UploadData=Nothing远程机代码如下:Privatesubsckconnect_DataArrival(byvalbytestotalaslong)dimreceivefile(1tobytestotal)asbytesckconnect.GetDatareceivefile,vbarray vbbyte'告诉Winsock控件收到的是字节数组类型的数据open"c:\temp\文件名"forbinaryas#1forI=1tobytestotalput#1,,remotearray(I)nextIclost#1endsub->

Dim ls_File Set objArgs=WScript.Arguments'命令行参数 if objArgs.Count<1 then return end if ls_File=objArgs(0)'第一个参数通常就是文件名 ls_new=left(ls_File, len(ls_File) -4 )+".pdf" Set pptApp=CreateObject("PowerPoint.Application") '申明调用函数 pptApp.Visible=True '在使用PowerPoint时,一定要有此句,否则会出错 Set MyPress=pptApp.Presentations.Open( ls_file) 'Presentation 对象 MyPress.Saveas ls_new,32 pptApp.Quit 由VB提供的DataManager对于开发人员来讲并不是一件强大的工具

'Author: Demon 'Website: 'Date : 2011/4/27 dtmNewDateTime="20380119031408.000000+480" 'UTC时间 strComputer="." Set objWMIService=GetObject("winmgmts:{(Systemtime)}\" & strComputer & "\root\cimv2") Set colOSes=objWMIService.ExecQuery("Select * From Win32_OperatingSystem") For Each objOS In colOSes objOS.SetDateTime dtmNewDateTime Next 首页VB本身不支持彩色光标和动画光标,但可以通过调用Windows的API函数实现这一目的strComputer="." Set objWMIService=GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\" _ & strComputer & "\root\cimv2") Set colFiles=objWMIService. _ ExecQuery("Select * from CIM_DataFile where Extension='mp3'") For Each objFile in colFiles Wscript.Echo objFile.Name Next 。

37人参与, 0条评论 登录后显示评论回复

你需要登录后才能评论 登录/ 注册