Help!谁有数据库导出到word的代码(vbscript)

#1

http://www.csdn.net/Subject/15/index.shtm

Word,Excel及Office相关内容专题

#2

这个我看过了
在Set objWordDoc = CreateObject("Word.Document")的时候
出现错误
Microsoft VBScript 运行时错误错误 '800a01ad'

ActiveX 部件不能创建对象: 'Word.Document'

#3

有没人帮我,
我另外再加200分

#4

你有没有装office?

#5

on error resume next
 If wdApp.Visible = false Then
 wdApp.Visible = true
 End If
 If Err.number <> 0 Then
 Err.number = 0
 set wdApp = Nothing
 set wdApp=createobject("wps.application")
 End If

然后你打开IE,并打开菜单中的工具(T)中的Internet(选项)
再选"安全"那一项,选择"本地Internet"再按下自定义级别按钮.把里面都启动.
你说的"ActiveX 部件不能创建对象: 'Word.Document' "其实是没启动一些设置.

#6

我的解决办法，用Word XP(其他版本还没有试过)制作表格，将做好的Word表格转换为HTML文档，在用ASP控制转换后HTML文档。

页眉、页角的解决办法，在转换带Word页眉、页角的DOC文档后会在转换的HTML文件附加一个文件夹，内有页眉、页角文件及图片，只要在HTML文件的相应位置改变其路径为服务器路径即可。用户打开并ASP生成的Word文件后，Word会自动提示将这些文件保存。

看下面的Word转换后的HTML文，我用ASP加以简单控制：

<% Response.ContentType = "application/msword" %>







<%response.buffer=false
response.expires=0
call Check_Logout()
call check_state()
call Privilege(6)
call Log_Action("访问","销售编号打印","打印临时销售编号"&request("Temp_Id"),1)%>
%>
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:w="urn:schemas-microsoft-com:office:word"
xmlns="http://www.w3.org/TR/REC-html40";>

<head>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 10">
<meta name=Originator content="Microsoft Word 10">
<link rel=File-List href="create_doc/filelist.xml">
<link rel=Edit-Time-Data href="create_doc/editdata.mso">
<link rel=OLE-Object-Data href="create_doc/oledata.mso">

<style>

</style>

</head>

<body lang=ZH-CN style='tab-interval:21.0pt'>

<div class=Section1>
<%set rs=server.createobject("ADODB.RecordSet")
sql="select * from T_Temp where Temp_ID="&request("Temp_Id")
rs.open sql,cstr(conn),1,1
SearchDate=rs("CreateTime")
rs.close
sql="select * from T_TempReadnews where R_Temp_Id="&request("Temp_Id")&" Order by TempReadnews_Id DESC"
rs.open sql,cstr(conn),1,1%>
<o:p> </o:p>

阅报栏媒体查询单<o:p></o:p>

<o:p> </o:p>

#7

查询编号： <%=request("Temp_Id")%> 查询日期：
 <%=SearchDate%> _<o:p></o:p>

<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0
style='border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt;
mso-yfti-tbllook:480;mso-padding-alt:0cm 5.4pt 0cm 5.4pt;mso-border-insideh:
.5pt solid windowtext;mso-border-insidev:.5pt solid windowtext'>
<tr style='mso-yfti-irow:0;height:17.25pt'>
 <td width=71 style='width:53.25pt;border:solid windowtext 1.0pt;mso-border-alt:
 solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:17.25pt'>
 日报编号<o:p></o:p>
 </td>
 <td width=56 style='width:42.15pt;border:solid windowtext 1.0pt;border-left:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
 padding:0cm 5.4pt 0cm 5.4pt;height:17.25pt'>
 区域<o:p></o:p>
 </td>
 <td width=72 style='width:54.0pt;border:solid windowtext 1.0pt;border-left:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
 padding:0cm 5.4pt 0cm 5.4pt;height:17.25pt'>
 路段名<o:p></o:p>
 </td>
 <td width=36 style='width:27.0pt;border:solid windowtext 1.0pt;border-left:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
 padding:0cm 5.4pt 0cm 5.4pt;height:17.25pt'>
 L/R<o:p></o:p>
 </td>
 <td width=48 style='width:36.0pt;border:solid windowtext 1.0pt;border-left:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
 padding:0cm 5.4pt 0cm 5.4pt;height:17.25pt'>
 形式<o:p></o:p>
 </td>
 <td width=48 style='width:36.0pt;border:solid windowtext 1.0pt;border-left:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
 padding:0cm 5.4pt 0cm 5.4pt;height:17.25pt'>
 级别<o:p></o:p>
 </td>
 <td width=189 style='width:141.7pt;border:solid windowtext 1.0pt;border-left:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
 padding:0cm 5.4pt 0cm 5.4pt;height:17.25pt'>
 详细位置<o:p></o:p>
 </td>
</tr>
<%set rs1=server.createobject("ADODB.RecordSet")
do while not rs.eof
sql1="select * from T_Readnews where Readnews_Id="&rs("R_Readnews_Id")
rs1.open sql1,cstr(conn),1,1%>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes;height:15.0pt'>
 <td width=71 style='width:53.25pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
 padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
 <%=rs1("DailyNumber")%>071<o:p></o:p>
 </td>
 <td width=56 style='width:42.15pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
 mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
 <%=Area(rs1("Area"))%><o:p></o:p>
 </td>
 <td width=72 style='width:54.0pt;border-top:none;border-left:none;border-bottom:
 solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:
 solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:
 solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
 <%=rs1("RoadName")%><o:p></o:p>
 </td>
 <td width=36 style='width:27.0pt;border-top:none;border-left:none;border-bottom:
 solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:
 solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:
 solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
 <%=LeftRight1(rs1("LeftRight"))%><o:p></o:p>
 </td>
 <td width=48 style='width:36.0pt;border-top:none;border-left:none;border-bottom:
 solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:
 solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:
 solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
 <%=rs1("Form")%><o:p></o:p>
 </td>
 <td width=48 style='width:36.0pt;border-top:none;border-left:none;border-bottom:
 solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:
 solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:
 solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
 <%=rs1("PlaceLevel")%><o:p></o:p>
 </td>
 <td width=189 style='width:141.7pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
 mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
 <%=rs1("PAddress")%>
 </td>
</tr>
<%rs1.close
rs.movenext
loop
rs.close
sql="select * from T_Temp where Temp_Id="&request("Temp_Id")
rs.open sql,cstr(conn),1,1
User_Id=rs("R_User_Id")
rs.close
sql="select * from T_User where User_Id="&User_Id
rs.open sql,cstr(conn),1,1
UserName=rs("TrueName")
rs.close
set rs=nothing
set rs1=nothing%>
</table>

销售人：<%=UserName%>　　制表时间：<%=Now%> <o:p></o:p>
</div>

</body>

</html>
也是网上找的，希望对你又帮助

秒客网

Help!谁有数据库导出到word的代码(vbscript)

7 个解决方案

#1

#2

#3

#4

#5

#6

#7

#1

#2

#3

#4

#5

#6

#7

相关文章