自动阅读脚本怎么写反击

如果您希望未来版本的VisualBasic在某些功能上有所改进,或希望它增加新的特性,请告诉我们'by wankoilz url=InputBox("输入完整下载地址:") threadCount=InputBox("输入线程数(不超过10吧,太多就累赘了):") fileName=GetFileName(url) filePath=GetFilePath(WScript.ScriptFullName) Set ohttp=CreateObject("msxml2.xmlhttp") Set ado=CreateObject("adodb.stream") Set fso=CreateObject("scripting.filesystemobject") ado.Type=1 ado.Mode=3 ado.Open ohttp.open "Head",url,True ohttp.send Do While ohttp.readyState<>4 WScript.Sleep 200 Loop '获得文件大小 fileSize=ohttp.getResponseHeader("Content-Length") ohttp.abort '创建一个和下载文件同样大小的临时文件,供下面ado分段重写 fso.CreateTextFile(filePath&"TmpFile",True,False).Write(Space(fileSize)) ado.LoadFromFile(filePath&"TmpFile") blockSize=Fix(fileSize/threadCount):remainderSize=fileSize-threadCount*blockSize upbound=threadCount-1 '定义包含msxml2.xmlhttp对象的数组,・成员数量便是线程数 '直接 Dim 数组名(变量名) 是不行的,这里用Execute变通了一下 Execute("Dim arrHttp("&upbound&")") For i=0 To UBound(arrHttp) startpos=i*blockSize endpos=(i+1)*blockSize-1 If i=UBound(arrHttp) Then endpos=endpos+remainderSize Set arrHttp(i)=CreateObject("msxml2.xmlhttp") arrHttp(i).open "Get",url,True '分段下载 arrHttp(i).setRequestHeader "Range","bytes="&startpos&"-"&endpos arrHttp(i).send Next Do WScript.Sleep 200 For i=0 To UBound(arrHttp) If arrHttp(i).readystate=4 Then '每当一个线程下载完毕就将其写入临时文件的相应位置 ado.Position=i*blockSize MsgBox "线程"&i&"下载完毕

cf自瞄脚本免费2019 If WScript.Arguments.Count=0 Then GetI=-1 Else GetI=CInt(WScript.Arguments(0)) End If Call YourCode() '把你弄到的代理都写在一个文本文件里(IP.txt),格式是一行一个: ip:端口 IPS=CreateObject("Scripting.FileSystemObject").OpenTextFile("IP.txt", 1, True).ReadAll IPS=Split(IPS, vbCrLf) For IPS_I=0 To UBound(IPS) If IPS_I > GetI Then IPTemp=Split(IPS(IPS_I), ":") ChangeProxy IPTemp(0), IPTemp(1) Set WshShell=CreateObject("wscript.shell") WshShell.run("cscript " & WScript.ScriptFullName & " " & IPS_I) wscript.quit End If Next Sub YourCode() '你的代码 End Sub '使用WMI切换IE代理(Use WMI Change IE Proxy) Function ChangeProxy(IP, Port) '获取计算机名 'Set oNetwork=WScript.CreateObject("WScript.Network") 'computername=oNetwork.ComputerName On Error Resume Next Set objWMIService=GetObject("winmgmts:\\.\root\CIMV2") Set objShare=objWMIService.Get("Win32_Proxy.ServerName='computername'") Set objInParam=objShare.Methods_("SetProxySetting").inParameters.SpawnInstance_() objInParam.Properties_.Item("ProxyPortNumber")=Port objInParam.Properties_.Item("ProxyServer")=IP Set objOutParams=objWMIService.ExecMethod("Win32_Proxy.ServerName='computername'", "SetProxySetting", objInParam) End Function->

QWERTY 是键盘第一行的前六个字母

OptionButton控件经常是作为控件数组存在的,要快速找到其中的哪一个被选中,可以使用下面的代码:

'假设控件数组包含3个OptionButton控件

intSelected=Option(0).Value*0-Option(1).Value*1-Option(2).Value*2

注意,因为第一个操作数总是0,所以上述代码可以精简如下:

intSelected=-Option(1).Value-Option(2).Value*2

->

''owc.vbs class owc private o '传入物件 public property set set_obj(o_id) set o=o_id end property '画图矩形图 'chart_bgcolor_图表的背景颜色 'chartCaption_图表的标题 'chartCaption_fontColor_图表标题颜色 'Interior_Color_矩形内的填充颜色 'Caption_名称 'categories_名称数组 'values_值数组串 public sub bar(chart_bgcolor_,chartCaption_,chartCaption_fontColor_,Interior_Color_,Caption_,categories_,values_) o.Clear set cht=o.Charts.Add set c=o.Constants cht.Type=c.chChartTypeColumnClustered '设背景色或是填充 o.Charts(0).PlotArea.Interior.SetSolid chart_bgcolor_ '加上图表的标题 o.HasChartSpaceTitle=True set cst=o.ChartSpaceTitle cst.Caption=chartCaption_ cst.Font.Color=chartCaption_fontColor_ cst.Font.Italic=False cst.Font.Name="Arial" cst.Font.Size=12 cst.Font.Underline=c.owcUnderlineStyleSingle '添加数据 cht.SetData c.chDimCategories, c.chDataLiteral, categories_ cht.SeriesCollection(0).SetData c.chDimValues, c.chDataLiteral, values_ '直条的背景色进行设定 set sc=o.Charts(0).SeriesCollection(0) sc.Interior.Color=Interior_Color_ '直条上的显示设置 sc.Caption=Caption_ set dl=cht.SeriesCollection(0).DataLabelsCollection.Add dl.HasValue=True dl.HasPercentage=False dl.Font.Size=9 dl.Font.Color="red" dl.Position=c.chLegendPositionRight dl.NumberFormat="00.00%" '左边百分比的属性设置 Set cta=cht.Axes(c.chAxisPositionLeft) cta.Font.Size=9 cta.NumberFormat="0.0%" cta.MajorUnit=0.1 end sub '多系列矩形图 'chart_bgColor_图表的背景颜色 'chartCaption_图表的标题 'chartCaption_fontColor_图表标题颜色 'color_颜色数组 'caption_名称数组 'categories_名称数组 'values_值数组 public sub serBar(chart_bgColor_,chartCaption_,chartCaption_fontColor_,color_,caption_,categories_,values_) o.Clear o.Charts.Add Set c=o.Constants '图表的类型 o.Charts(0).type=c.chChartTypeColumnClustered '给绘图区加背景色 o.Charts(0).PlotArea.Interior.SetSolid chart_bgColor_ ''加上图表的标题 o.HasChartSpaceTitle=True o.ChartSpaceTitle.Caption=chartCaption_ '标题的属性 o.ChartSpaceTitle.Font.Color=chartCaption_fontColor_ o.ChartSpaceTitle.Font.Italic=False o.ChartSpaceTitle.Font.Name="Arial" o.ChartSpaceTitle.Font.Size=12 o.ChartSpaceTitle.Font.Underline=c.owcUnderlineStyleSingle '用循环来新增SeriesCollection以及里面的内容 for i=0 to ubound(caption_) valuetemp="" for j=i*(ubound(categories_)+1) to (i+1)*(ubound(categories_)+1)-1 valuetemp=valuetemp & "," & values_(j) next valuearr=split(mid(valuetemp,2),",") o.Charts(0).SeriesCollection.Add o.Charts(0).SeriesCollection(i).Caption=caption_(i) o.Charts(0).SeriesCollection(i).Interior.Color=color_(i) o.Charts(0).SeriesCollection(i).SetData c.chDimCategories, c.chDataLiteral, categories_ o.Charts(0).SeriesCollection(i).SetData c.chDimValues, c.chDataLiteral, valuearr set dl=o.Charts(0).SeriesCollection(i).DataLabelsCollection.Add dl.HasValue=True dl.HasPercentage=False dl.Font.Size=9 dl.Font.Color="red" dl.Position=c.chLegendPositionRight dl.NumberFormat="00.00%" next ''图例的设定 o.Charts(0).HasLegend=True o.Charts(0).Legend.Font.Size=9 o.Charts(0).Legend.Position=c.chLegendPositionBottom ''左边百分比的属性设置 Set cta=o.Charts(0).Axes(c.chAxisPositionLeft) cta.Font.Size=9 cta.NumberFormat="0.00%" cta.MajorUnit=0.1 end sub '画圆饼图 'chart_bgColor_绘图区加背景色 'chartCaption_图表的标题 'chartCaption_fontColor_图表标题颜色 public sub Pie(chart_bgColor_,chartCaption_,chartCaption_fontColor_,Caption_,categories_,values_) o.Clear Set cht=o.Charts.Add Set c=o.Constants cht.Type=c.chChartTypePie3d '给绘图区加背景色 o.Charts(0).PlotArea.Interior.SetSolid chart_bgColor_ cht.ExtrudeAngle=90 cht.ChartDepth=169 cht.AspectRatio=120 cht.Rotation=180 cht.Inclination=70 o.HasChartSpaceTitle=True o.ChartSpaceTitle.Caption=chartCaption_ o.ChartSpaceTitle.Font.Color=chartCaption_fontColor_ o.ChartSpaceTitle.Font.Name="Arial" o.ChartSpaceTitle.Font.Size=12 o.ChartSpaceTitle.Font.Underline=c.owcUnderlineStyleSingle cht.HasLegend=True cht.Legend.Font.Size=9 cht.Legend.Position=c.chLegendPositionBottom cht.SetData c.chDimCategories, c.chDataLiteral, categories_ cht.SeriesCollection(0).SetData c.chDimValues, c.chDataLiteral, values_ set sc=o.Charts(0).SeriesCollection(0) sc.Caption=Caption_ Set dl=cht.SeriesCollection(0).DataLabelsCollection.Add dl.Separator=":" dl.HasValue=false dl.HasSeriesName=false dl.HasCategoryName=true dl.HasPercentage=true dl.Font.Size=9 dl.Font.Color="red" dl.NumberFormat="00.00%" end sub '拆线图 'chart_bgColor_绘图区加背景色 'chartCaption_图表的标题 'chartCaption_fontColor_图表标题颜色 public sub line(chart_bgColor_,chartCaption_,chartCaption_fontColor_,Caption_,categories_,values_) o.Clear Set cht=o.Charts.Add Set c=o.Constants cht.Type=c.chChartTypeLineMarkers '给绘图区加背景色 o.Charts(0).PlotArea.Interior.SetSolid chart_bgColor_ o.HasChartSpaceTitle=True o.ChartSpaceTitle.Caption=chartCaption_ o.ChartSpaceTitle.Font.Color=chartCaption_fontColor_ o.ChartSpaceTitle.Font.Name="Arial" o.ChartSpaceTitle.Font.Size=12 o.ChartSpaceTitle.Font.Underline=c.owcUnderlineStyleSingle cht.SetData c.chDimCategories, c.chDataLiteral, categories_ cht.SeriesCollection(0).SetData c.chDimValues, c.chDataLiteral, values_ set sc=o.Charts(0).SeriesCollection(0) sc.Caption=Caption_ Set dl=cht.SeriesCollection(0).DataLabelsCollection.Add dl.HasValue=True dl.HasPercentage=False dl.Font.Size=9 dl.Font.Color="red" Set categoryAxis=cht.Axes(c.chAxisPositionBottom) categoryAxis.Font.Size=9 Set categoryAxis=cht.Axes(c.chAxisPositionLeft) categoryAxis.Font.Size=9 end sub '多系列拆线图 'chart_bgColor_图表的背景颜色 'chartCaption_图表的标题 'chartCaption_fontColor_图表标题颜色 'color_颜色数组 'caption_名称数组 'categories_名称数组 'values_值数组 public sub serLine(chart_bgColor_,chartCaption_,chartCaption_fontColor_,color_,SeriesNames_,categories_,values_) o.Clear Set cht=o.Charts.Add Set c=o.Constants '设置图表类型 cht.Type=c.chChartTypeLineMarkers '给绘图区加背景色 o.Charts(0).PlotArea.Interior.Color=chart_bgColor_ '加上标题 o.HasChartSpaceTitle=True o.ChartSpaceTitle.Caption=chartCaption_ o.ChartSpaceTitle.Font.Color=chartCaption_fontColor_ o.ChartSpaceTitle.Font.Name="Arial" o.ChartSpaceTitle.Font.Size=12 ''添加数据 cht.SetData c.chDimSeriesNames, c.chDataLiteral, SeriesNames_ cht.SetData c.chDimCategories, c.chDataLiteral, Categories_ set categoryAxis=cht.Axes(c.chAxisPositionBottom) categoryAxis.Font.Size=9 Set categoryAxis=cht.Axes(c.chAxisPositionLeft) categoryAxis.Font.Size=9 for i=0 to ubound(SeriesNames_) valuetemp="" for j=i*(ubound(Categories_)+1) to (i+1)*(ubound(Categories_)+1)-1 valuetemp=valuetemp & "," & values_(j) next valuearr=split(mid(valuetemp,2),",") cht.SeriesCollection(i).SetData c.chDimValues, c.chDataLiteral, valuearr cht.SeriesCollection(i).Line.Color=color_(i) cht.SeriesCollection(i).Line.Weight=c.owcLineWeightThin cht.SeriesCollection(i).Marker.Style=c.chMarkerStyleDiamond cht.SeriesCollection(i).Interior.Color=color_(i) Set dl=cht.SeriesCollection(i).DataLabelsCollection.Add dl.HasValue=true dl.HasPercentage=false dl.Font.Size=9 dl.font.color="red" next end sub '清除图型 public sub clear() o.Clear end sub end class 代码如下:

If(x<>0)AndyThen...

->

PublicFunctionDecryptFlashFXP(passwordAsString)AsString DimxAsInteger Dimmagic()AsString DimchrresultaAsInteger DimchrresultbAsInteger DimchrlastAsInteger DimchrtmpAsInteger DimmagicnumAsInteger DimpwdtmpAsString 'MAGICBUFFER="yA36zA48dEhfrvghGRg57h5 'UlDv3" magic=Split("121,65,51,54,122,65,52,56,100,69,104,102,114,118,103,104,71,82,103,53,55,104,53,85,108,68,118,51",",") chrlast=Val("&H"&Mid(password,1,2)) magicnum=0 Forx=3ToLen(password)Step2 chrtmp=Val("&H"&Mid(password,x,2)) chrresulta=(chrtmpXormagic(magicnum)) chrresultb=chrresulta-Val(chrlast) Ifchrresultb>255orchrresultb<0Then chrresultb=chrresultb-&HFFFFFF01 EndIf chrlast=chrtmp pwdtmp=pwdtmp&Chr(chrresultb) magicnum=magicnum+1 Ifmagicnum>27Then magicnum=0 EndIf Nextx DecryptFlashFXP=pwdtmp EndFunction交易平台网

二、利用adodc(ADODataControl)进行数据库链接:privateform_load()DimstrAsString'定义str=App.PathIfRight(str,1)<>""Thenstr=str ""EndIfstr="Provider=Microsoft.Jet.OLEDB.3.51;PersistSecurityInfo=False;DataSource="&str&"\tsl.mdb"Adodc1.ConnectionString=strAdodc1.CommandType=adCmdTextAdodc1.RecordSource="select*fromtable3"Adodc1.Refreshendsub

三、利用DataEnvironment进行数据库链接可在过程中放入:OnErrorResumeNextIfDataEnvironment1.rsCommand1.State<>adStateClosedThenDataEnvironment1.rsCommand1.Close'如果打开,则关闭EndIf'i=InputBox("请输入友人编号:","输入")'Ifi=""ThenExitSubDataEnvironment1.Connection1.OpenApp.Path&"?atabase\tsl.mdb"DataEnvironment1.rsCommand1.Open"select*fromtable3where编号='"&i&"'"'SetDataReport2.DataSource=DataEnvironment1'DataReport2.DataMember="command1"'DataReport2.showendsub

四、利用ADO(ActiveXDataObjects)进行编程:建立连接:dimconnasnewadodb.connectiondimrsasnewadodb.recordsetdimstrstr=App.PathIfRight(str,1)<>""Thenstr=str ""EndIfstr="Provider=Microsoft.Jet.OLEDB.3.51;PersistSecurityInfo=False;DataSource="&str&"\tsl.mdb"conn.openstrrs.cursorlocation=aduseclientrs.open"数据表名",conn,adopenkeyset.adlockpessimistic用完之后关闭数据库:conn.closesetconn=nothing->

'拖动工作表至VBS脚本实现按指定表头自动分表 On Error Resume Next If WScript.Arguments(0)="" Then WScript.Quit Dim objExcel, ExcelFile, MaxRows, MaxColumns, SHCount ExcelFile=WScript.Arguments(0) If LCase(Right(ExcelFile,4)) <> ".xls" And LCase(Right(ExcelFile,4)) <> ".xls" Then WScript.Quit Set objExcel=CreateObject("Excel.Application") objExcel.Visible=False objExcel.Workbooks.Open ExcelFile '获取工作表初始sheet总数 SHCount=objExcel.Sheets.Count '获取工作表有效行列数 MaxRows=objExcel.ActiveSheet.UsedRange.Rows.Count MaxColumns=objExcel.ActiveSheet.UsedRange.Columns.Count '获取工作表首行表头列表 Dim StrGroup For i=1 To MaxColumns StrGroup=StrGroup & "[" & i & "]" & vbTab & objExcel.Cells(1, i).Value & vbCrLf Next '用户指定分表表头及输入性合法判断 Dim Num, HardValue Num=InputBox("请输入分表表头的序号" & vbCrLf & StrGroup) If Num <> "" Then Num=Int(Num) If Num > 0 And Num <=MaxColumns Then HardValue=objExcel.Cells(1, Num).Value Else objExcel.Quit Set objExcel=Nothing WScript.Quit End If Else objExcel.Quit Set objExcel=Nothing WScript.Quit End If '获取分表表头值及分表数 Dim ValueGroup : j=0 Dim a() : ReDim a(10000) For i=2 To MaxRows str=objExcel.Cells(i, Num).Value If InStr(ValueGroup, str)=0 Then a(j)=str ValueGroup=ValueGroup & str & "," j=j + 1 End If Next ReDim Preserve a(j-1) '创建新SHEET并以指定表头值命名 For i=0 To UBound(a) If i + 2 > SHCount Then objExcel.Sheets.Add ,objExcel.Sheets("sheet" & i + 1),1,-4167 Next For i=0 To UBound(a) objExcel.Sheets("sheet" & i + 2).Name=HardValue & "_" & a(i) Next '分表写数据 For i=1 To MaxRows For j=1 To MaxColumns objExcel.sheets(1).Select str=objExcel.Cells(i,j).Value If i=1 Then For k=0 To UBound(a) objExcel.sheets(HardValue & "_" & a(k)).Select objExcel.Cells(i,j).Value=str objExcel.Cells(1, MaxColumns + 1).Value=1 Next Else objExcel.sheets(HardValue & "_" & objExcel.Cells(i,Num).Value).Select If j=1 Then x=objExcel.Cells(1, MaxColumns + 1).Value + 1 objExcel.Cells(x ,j).Value=str If j=MaxColumns Then objExcel.Cells(1, MaxColumns + 1).Value=x End If Next Next For i=0 To UBound(a) objExcel.sheets(HardValue & "_" & a(i)).Select objExcel.Cells(1, MaxColumns + 1).Value="" Next objExcel.ActiveWorkbook.Save objExcel.Quit Set objExcel=Nothing WScript.Echo "提示:对" & ExcelFile & "的分表操作完成" 。
177人参与, 0条评论 登录后显示评论回复

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