level 2
276542471
楼主
sub mj(fol,tab)set fso1=createobject("scripting.filesystemobject")set folder1=fso1.getfolder(fol)set folders1=folder1.subfoldersfor each fo in folders1 writeconn fo,tabnextend subsub writeconn(varfo,vartab)set conn=createobject("adodb.connection")set rs=createobject("adodb.recordset")conn.open "provider=microsoft.jet.oledb.4.0;data source=game.xls;extended properties=excel 8.0;"rs.open "select * from " & vartab,conn,1,3rs.addnewrs("path")=varfors.updateend subsub readconn(vartab)set conn=createobject("adodb.connection")set rs=createobject("adodb.recordset")conn.open "provider=microsoft.jet.oledb.4.0;data source=game.xls;extended properties=excel 8.0;"rs.open "select * from " & vartab,conn,1,1do while not rs.eof'msgbox rs("title") lnk rs("title"),rs("path"),rs("run")rs.movenextloopend subSub lnk(varmys,varwor,vartar)Dim wshshellSet wshshell = CreateObject("wscript.shell")Dim myshortcut, mydesktop, desktoppathdesktoppath = wshshell.specialfolders("desktop")Set myshortcut = wshshell.createshortcut(desktoppath & "\game\lnk\" & varmys & ".lnk")myshortcut.targetpath = wshshell.expandenvironmentstrings(vartar)myshortcut.workingdirectory = wshshell.expandenvironmentstrings(varwor)myshortcut.windowstyle = 4myshortcut.iconlocation = wshshell.expandenvironmentstrings(vartar & ",0")myshortcut.SaveEnd Sub'mj "d:\tools","[tools$]"'msgbox "end"
2005年12月21日 12点12分
1