1
<PRE lang=cs id=pre1 style="MARGIN-TOP: 0px" nd="24"><script language="vbscript">
2![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
Function Export(objToExport)
4![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
ON ERROR RESUME NEXT
6
DIM sHTML, oExcel, fso, filePath
7![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
sHTML = document.all(objToExport).outerHTML
9![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
10
SET fso = CreateObject("Scripting.FileSystemObject")
11
filePath = fso.GetSpecialFolder(2) & "\MyExportedExcel.xls"
12
fso.CreateTextFile(filePath).Write(sHTML)
13![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
14
DIM i
15
SET i = 0
16![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
17
DO WHILE err.number > 0
18
err.Clear()
19
filePath = fso.GetSpecialFolder(2) &
20
"\MyExportedExcel" & i & ".xls"
21
fso.CreateTextFile(filePath).Write(sHTML)
22![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
23
i = i + 1
24
LOOP
25![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
26
SET oExcel = CreateObject("Excel.Application")
27
IF err.number>0 OR oExcel =NULL THEN
28
msgbox("You need to have Excel Installed and Active-X
29
Components Enabled on your System.")
30
EXIT FUNCTION
31
END IF
32![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
33
oExcel.Workbooks.open(filePath)
34
oExcel.Workbooks(1).WorkSheets(1).Name = "My Excel Data"
35
oExcel.Visible = true
36
Set fso = Nothing
37![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
38
End Function
39![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
40
</script>
41
</PRE>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
9
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
10
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
11
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
12
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
13
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
14
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
15
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
16
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
17
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
18
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
19
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
20
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
21
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
22
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
23
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
24
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
25
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
26
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
27
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
28
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
29
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
30
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
31
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
32
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
33
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
34
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
35
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
36
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
37
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
38
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
39
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
40
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
41
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
为啥看不到呢?