<?xml version="1.0" encoding="gb2312"?>

<!-- RSS generated by oioj.net on 4/16/2004 ; 感谢LeXRus提供 RSS 2.0 文档; 此文件可自由使用，但请保留此行信息 --> 
<!-- Source download URL: http://blogger.org.cn/blog/rss2.asp       -->
<rss version="2.0">

<channel>
<title>注册会计师（注会）练习软件</title>
<link>http://blogger.org.cn/blog/blog.asp?name=lxy7105</link>
<description>吕向阳的博客</description>
<copyright>blogger.org.cn</copyright>
<generator>W3CHINA Blog</generator>
<webMaster>webmaster@blogger.org.cn</webMaster>
<item>
<title><![CDATA[软件官网终于通过了备案]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=73498</link>
<author>lxy7105</author>
<pubDate>2016/11/16 20:29:40</pubDate>
<description><![CDATA[<a>　我的CPASOFT.COM.CN 终于通过了工信部网站备案，真心麻烦。<br><br>访问：&nbsp; www.cpasoft.com.cn<br></a>]]></description>
</item><item>
<title><![CDATA[科目余额表生成审计工作底稿工具]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=73291</link>
<author>lxy7105</author>
<pubDate>2014/12/8 20:54:14</pubDate>
<description><![CDATA[<h2 class="title content-title">科目余额表生成审计工作底稿工具</h2>     <p><span style="font-size: 12px;"><a href="http://pan.baidu.com/s/1gd6Ctd5" target="_blank">下载地址&nbsp;&nbsp; http://pan.baidu.com/s/1gd6Ctd5</a>(更新日期 2014-12-08）</span></p><p><span style="font-size: 12px;"><br></span></p><p><span style="font-size: 12px;">历史版本&nbsp; <a href="http://pan.baidu.com/s/1sj14d9V" target="_blank">http://pan.baidu.com/s/1sj14d9V</a> <br></span></p><p><strong><span style="color: #0070c0;">&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;使用简介</span></strong></p><p><strong><span style="color: #0070c0;">2014-12-8更新</span></strong></p><p><strong><span style="color: #0070c0;">1）、除了企业会计准则的模板外，另外引入小企业模板、事业单位、行政单位、国资模板</span></strong></p><p><strong><span style="color: #0070c0;">2）、
加入了批量打印底稿的功能 。平时 
我们打印底稿需要逐张设置纸张大小，横向纵向，调节页面，本工具能自动帮你完成，它会根据表格的大小自动调整缩旋比，自动确定纸张横向纵向，并且按一次打
印可打工作簿中选定的任意多个表格，或全部表格，也可选定多个工作簿一次打印全部的底稿文件 。</span></strong></p><p><strong><span style="color: #0070c0;">3）、能够方便地生成各种函证，银行询证函，企业往来询证函，交易询证函，信封等，并且支持多行数据出现在一个函证里。</span></strong></p><p><strong><span style="color: #0070c0;">4）、加入了对OFFICE2007,OFFICE2010,OFFICE2013支持，更友好的界面。</span></strong></p>]]></description>
</item><item>
<title><![CDATA[取股票日线代码]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=72822</link>
<author>lxy7105</author>
<pubDate>2012/9/19 20:14:15</pubDate>
<description><![CDATA[<P>unit USTOCKS;</P>
<P>interface</P>
<P>uses system.IO;<BR>const HS = 85;<BR>type<BR>&nbsp; dayline = record<BR>&nbsp;&nbsp;&nbsp; date: double;<BR>&nbsp;&nbsp;&nbsp; startj: double;<BR>&nbsp;&nbsp;&nbsp; maxj: double;<BR>&nbsp;&nbsp;&nbsp; minj: double;<BR>&nbsp;&nbsp;&nbsp; endj: double;<BR>&nbsp;&nbsp;&nbsp; a6: double;<BR>&nbsp;&nbsp;&nbsp; totalsl: double;<BR>&nbsp;&nbsp;&nbsp; a8: double;<BR>&nbsp; end;</P>
<P>type<BR>&nbsp; xSTOCKS = class<BR>&nbsp; private<BR>&nbsp;&nbsp;&nbsp; { Private Declarations }<BR>&nbsp;&nbsp;&nbsp; fcount: integer;<BR>&nbsp;&nbsp;&nbsp; fmax, fmin: double;<BR>&nbsp; public<BR>&nbsp;&nbsp;&nbsp; lines: array of dayline;<BR>&nbsp;&nbsp;&nbsp; procedure GETFROMFILE();<BR>&nbsp;&nbsp;&nbsp; property count: integer read fcount ;<BR>&nbsp;&nbsp;&nbsp; property max: double read fmax;<BR>&nbsp;&nbsp;&nbsp; property min: double read fmin;<BR>&nbsp;&nbsp;&nbsp; function&nbsp; GETMC(DM:STRING):string;<BR>&nbsp; end;</P>
<P>implementation</P>
<P>procedure xSTOCKS.GETFROMFILE;<BR>var fs: filestream;<BR>&nbsp; myreader: binaryreader;<BR>&nbsp; i: integer;<BR>&nbsp; length: integer;<BR>begin<BR>&nbsp; fmax := 0;</P>
<P>&nbsp; fs := filestream.Create('C:\同花顺核新\history\shase\day\600806.day', filemode.Open, fileaccess.Read);<BR>&nbsp; myreader := binaryreader.Create(fs);</P>
<P>//&nbsp; length := convert.ToInt16((fs.get_Length - 64) / 48);<BR>&nbsp; length := convert.ToInt16((fs.get_Length - 72) / 56);<BR>&nbsp; fcount:=length;<BR>&nbsp; fs.Seek(72, SeekOrigin.&amp;Begin);</P>
<P>&nbsp; if length &gt;= HS then<BR>&nbsp; begin<BR>&nbsp;&nbsp;&nbsp; setlength(lines, HS);<BR>&nbsp;&nbsp;&nbsp; fs.seek((length - HS) * 56, seekorigin.Current);<BR>&nbsp;&nbsp;&nbsp; fcount := HS;<BR>&nbsp; end<BR>&nbsp; else<BR>&nbsp; begin<BR>&nbsp;&nbsp;&nbsp; setlength(lines, length);<BR>&nbsp;&nbsp;&nbsp; fcount := length;<BR>&nbsp; end;</P>
<P>&nbsp; for I := 0 to fcount - 1 do<BR>&nbsp; begin<BR>&nbsp;&nbsp;&nbsp; //读取数据<BR>&nbsp;&nbsp;&nbsp; lines[i].date := myreader.ReadInt32;<BR>&nbsp;&nbsp;&nbsp; lines[i].startj := (myreader.ReadInt32 shl 8 shr 8) / 1000;<BR>&nbsp;&nbsp;&nbsp; lines[i].maxj := (myreader.ReadInt32 shl 8 shr 8) / 1000;</P>
<P>&nbsp;&nbsp;&nbsp; if (fmax &lt; lines[i].maxj) then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fmax := lines[i].maxj;</P>
<P>&nbsp;&nbsp;&nbsp; lines[i].minj := (myreader.ReadInt32 shl 8 shr 8) / 1000;<BR>&nbsp;&nbsp;&nbsp; if (i = 0) then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fmin := lines[i].minj<BR>&nbsp;&nbsp;&nbsp; else<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (fmin &gt; lines[i].minj) then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fmin := lines[i].minj;</P>
<P>&nbsp;&nbsp;&nbsp; lines[i].endj := (myreader.ReadInt32 shl 8 shr 8) / 1000;<BR>&nbsp;&nbsp;&nbsp; fs.Seek(36, SeekOrigin.Current);<BR>&nbsp; //<BR>&nbsp; end;<BR>&nbsp; myreader.Close;<BR>&nbsp; fs.Close;<BR>end;</P>
<P>&nbsp;</P>
<P>function xSTOCKS.GETMC(DM: STRING):string;<BR>var fs: filestream;<BR>&nbsp; myreader: binaryreader;<BR>&nbsp; i: integer;<BR>&nbsp; length: integer;<BR>&nbsp; GPDM,GPNAME:STRING;</P>
<P>begin<BR>&nbsp; {fmax := 0;</P>
<P>&nbsp; fs := filestream.Create('C:\同花顺核新\realtime\shase\STOCKNOW.DAT', filemode.Open, fileaccess.Read);<BR>&nbsp; myreader := binaryreader.Create(fs);</P>
<P>&nbsp; length := convert.ToInt16((fs.get_Length - 64) / 48);<BR>&nbsp; fs.Seek(176, SeekOrigin.&amp;Begin);</P>
<P>//&nbsp; for I:=0 to LENGTH - 1 do<BR>&nbsp; BEGIN<BR>&nbsp;//&nbsp;&nbsp; fs.Seek(1, SeekOrigin.Current);<BR>&nbsp;&nbsp;&nbsp; GPDM:=copy(MYREADER.ReadString,0);<BR>&nbsp; end;</P>
<P>&nbsp; myreader.Close;<BR>&nbsp; fs.Close;}<BR>&nbsp; result:='';<BR>end;</P>
<P>end.<BR></P>]]></description>
</item><item>
<title><![CDATA[电话号簿联系人存入SIM卡的攻略]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=72805</link>
<author>lxy7105</author>
<pubDate>2012/9/5 9:19:15</pubDate>
<description><![CDATA[
<P>因为HTC G2手机的待机时间太短，我换了一个NOKIA只能接打电话发短信的待机王。这样悲剧就来了：G2里面的手机号码太多，用尽了android系统下所有的可以复制号码到sim卡的软件，均只能复制号码，在NOKIA的待机王中均不能正确显示联系人的姓名。&lt;/br&gt;</P>
<P>不得以，只得开始的我不断探索之旅，其间不断地切换各种手机，各种号簿管理软件，号码导入导出工具。&lt;/br&gt;</P>
<P>最后的解决是用qqpim号码同步软件过渡，用另一台NOKIA e63成功复制到了sim.过程是这样的。</P>
<P>&lt;/br&gt;</P>
<P>G2上下载一个G2版的qqpim号码同步软件软件，然后将G2中的电话簿同步到QQ上，然后找一个NOKIA e63,也下载个e63版的qqpim,然后将其导入到E63中，最后用E63的号码复制功能，将电话簿存入了SIM卡。</P>
<P>&lt;/br&gt;</P>
<P>费时6个小时，其实这时间一个一个电话往里灌都可以的啦。</P>]]></description>
</item><item>
<title><![CDATA[DELPHI编程中窗体的主菜单不显示的原因]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=52787</link>
<author>lxy7105</author>
<pubDate>2011/12/6 17:09:27</pubDate>
<description><![CDATA[<P>在做软件的过程中，发现加了一个插件alpha control皮肤控件后，怎么都无法将主菜单mainmenu显示出来。</P>
<P>&nbsp; 经过反复的实验，最后锁定在主窗体的属性 borderstyle的值为bsDialog，将其改为bsSizeable，主菜单如期而至。可能是这些皮肤插件自动将这个属性改为了bsdialog的原因。</P>]]></description>
</item><item>
<title><![CDATA[word格式财务报表附注生成工具]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=52736</link>
<author>lxy7105</author>
<pubDate>2011/12/1 13:19:52</pubDate>
<description><![CDATA[
<TABLE style="TABLE-LAYOUT: fixed; WIDTH: 100%">
<TBODY>
<TR>
<TD>
<DIV class=cnt style="OVERFLOW: hidden"><SPAN style="FONT-SIZE: 13.5pt; COLOR: blue; mso-bidi-: 0pt"><SPAN style="FONT-SIZE: 12px"><SPAN><SPAN style="FONT-SIZE: 12px; COLOR: blue">
<DIV>
<DIV>
<DIV><SPAN style="FONT-SIZE: 14px"></SPAN></DIV>
<DIV></DIV>
<DIV><SPAN><SPAN style="FONT-SIZE: 14px">联系方式 </SPAN><SPAN style="FONT-SIZE: 14px">Q Q:179930269&nbsp; &nbsp;Mail:abc7105@126.com</SPAN></SPAN></DIV>
<DIV><SPAN><SPAN style="FONT-SIZE: 14px">
<DIV><SPAN><SPAN style="FONT-SIZE: 14px">
<DIV><SPAN><SPAN style="FONT-SIZE: 14px">=======================================</SPAN></SPAN><SPAN><SPAN style="FONT-SIZE: 14px">&nbsp;</SPAN></SPAN></DIV>
<DIV><SPAN><SPAN style="FONT-SIZE: 14px">
<DIV target="_blank"><STRONG><SPAN style="FONT-SIZE: 18px; COLOR: #ff0000"><A href="http://1000eb.com/5l16">word格式财务报表附注生成工具下载具</A></SPAN></STRONG></DIV>
<DIV><SPAN><SPAN style="FONT-SIZE: 14px">=======================================</SPAN></SPAN><SPAN><SPAN style="FONT-SIZE: 14px">&nbsp;</SPAN></SPAN></DIV>
<DIV><SPAN><SPAN style="FONT-SIZE: 14px"><A href="http://1000eb.com/5l16"><IMG style="BORDER-LEFT-COLOR: #000000; BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-RIGHT-COLOR: #000000" height=46 src="http://blogger.org.cn/blog/uploadfile/20111216113922645.JPG" width=99 border=0></A></SPAN></SPAN></DIV>
<DIV></SPAN></SPAN><SPAN><SPAN style="FONT-SIZE: 14px">&nbsp;</DIV></DIV>
<DIV>
<DIV>
<DIV>你或许是一名CPA(注册会计师），或许是上市公司的财务人员，不管是年报，半年报、季报总少不了要写填那几十页的word格式财务报表附注。即使有EXCEL帮忙，加加减减，合并调整得出了一个EXCEL版本的附注，还要将它复制粘贴到WORD文档中，少不了调整格式，少不了担心复制错了地方，担心还有一些改动没有被复制....</DIV>
<DIV>&nbsp;</DIV>
<DIV>本工具就是为此应运而生的，它帮你建好EXCEL格式财务报表附注的框架（含合并），并同时建立一个对应的word格式附注文档，这个文档通过域链接到excel附注，当excel附注的内容发生改变时，只要回到word附注，按下f9键，word文档与excel文档就保持同步了。</DIV></DIV>
<DIV>&nbsp;</DIV>
<DIV></DIV>
<DIV><SPAN></SPAN>
<DIV>本工具的特点</DIV>
<DIV>1）、就是省去了你的复制粘贴操作，并且保证word附注文档与excel附注文档的随时同步。撰写附注效率飞速提高。</DIV>
<DIV>2）、使用操作步骤十分简单，只有简单的几个按钮。</DIV>
<DIV>3）、模板更改方便，财务报表附注每年的变动频繁，使用者可在系统提供的模板基础上灵活地添加相应的表格或文字后重新生成模板即可。</DIV>
<DIV>4）、本工具适用范围广，除了在财务报表附注上使用外，还可自定义模板，只要是需要word与excel同步的领域都可使用。</DIV>
<DIV>&nbsp;</DIV>
<DIV>使用界面截图如下：</DIV>
<DIV><A href="http://hiphotos.baidu.com/lxschool/pic/item/e436d658ccbf6c8188983da1bc3eb13532fa407b.jpg" target=_blank><SPAN></SPAN></A><IMG style="BORDER-LEFT-COLOR: #000000; BORDER-BOTTOM-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-RIGHT-COLOR: #000000" src="http://blogger.org.cn/blog/uploadfile/2011125994260.PNG" border=0><BR></DIV><BR></DIV></DIV></SPAN></SPAN></SPAN></SPAN></DIV></SPAN></SPAN></DIV></DIV></DIV></SPAN></SPAN></SPAN></SPAN></DIV></TD></TR></TBODY></TABLE>]]></description>
</item><item>
<title><![CDATA[在excel中一次性断开所有的链接]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=51704</link>
<author>lxy7105</author>
<pubDate>2011/7/15 12:47:32</pubDate>
<description><![CDATA[lks&nbsp;=&nbsp;ActiveWorkbook.LinkSources(Type:=xlLinkTypeExcelLinks)<BR>&nbsp;&nbsp;&nbsp;&nbsp;For&nbsp;i&nbsp;=&nbsp;1&nbsp;To&nbsp;UBound(lks)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ActiveWorkbook.BreakLink&nbsp;Name:=lks(i),&nbsp;Type:=xlLinkTypeExcelLinks<BR>&nbsp;&nbsp;&nbsp;&nbsp;Next<BR>]]></description>
</item><item>
<title><![CDATA[测试范例：delphi向excel写入宏代码,运行excel宏代码]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=51501</link>
<author>lxy7105</author>
<pubDate>2011/6/12 20:56:09</pubDate>
<description><![CDATA[procedure&nbsp;TForm1.Button2Click(Sender:&nbsp;TObject);<BR>var<BR>&nbsp;&nbsp;i:&nbsp;integer;<BR>&nbsp;&nbsp;PathName:&nbsp;string;<BR>&nbsp;&nbsp;oldcur:&nbsp;tcursor;<BR>&nbsp;&nbsp;FExcelApplication:&nbsp;TExcelApplication;<BR>&nbsp;&nbsp;FExcelWorkbook:&nbsp;TExcelWorkbook;<BR>&nbsp;&nbsp;FExcelWorksheet:&nbsp;TExcelWorksheet;<BR>&nbsp;&nbsp;xl:&nbsp;olevariant;<BR><BR>&nbsp;&nbsp;V:&nbsp;_VBComponent;<BR>&nbsp;&nbsp;vArg1,&nbsp;vArg2,&nbsp;vArg3,&nbsp;vArg4,&nbsp;vArg5,&nbsp;vArg6,&nbsp;vArg7,&nbsp;vArg8,&nbsp;vArg9,&nbsp;vArg10,<BR>&nbsp;&nbsp;&nbsp;&nbsp;vArg11,&nbsp;vArg12,&nbsp;vArg13,&nbsp;vArg14,&nbsp;vArg15,&nbsp;vArg16,&nbsp;vArg17,&nbsp;vArg18,&nbsp;vArg19,&nbsp;vArg20,<BR>&nbsp;&nbsp;&nbsp;&nbsp;vArg21,&nbsp;vArg22,&nbsp;vArg23,&nbsp;vArg24,&nbsp;vArg25,&nbsp;vArg26,&nbsp;vArg27,&nbsp;vArg28,&nbsp;vArg29,&nbsp;vArg30:&nbsp;OLEVariant;<BR><BR>begin<BR><BR>&nbsp;&nbsp;try<BR>&nbsp;&nbsp;&nbsp;&nbsp;FExcelApplication&nbsp;:=&nbsp;TExcelApplication.Create(nil);<BR>&nbsp;&nbsp;&nbsp;&nbsp;FExcelWorkbook&nbsp;:=&nbsp;TExcelWorkbook.Create(nil);<BR>&nbsp;&nbsp;&nbsp;&nbsp;FExcelWorkSheet&nbsp;:=&nbsp;TExcelWorksheet.Create(nil);<BR><BR>&nbsp;&nbsp;except<BR>&nbsp;&nbsp;&nbsp;&nbsp;showmessage('对不起，您没有安装Excel&nbsp;2000!');<BR>&nbsp;&nbsp;&nbsp;&nbsp;abort;<BR>&nbsp;&nbsp;end;<BR><BR>&nbsp;&nbsp;vArg1&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg2&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg3&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg4&nbsp;:=&nbsp;EmptyParam;<BR>&nbsp;&nbsp;vArg5&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg6&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg7&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg8&nbsp;:=&nbsp;EmptyParam;<BR>&nbsp;&nbsp;vArg9&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg10&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg11&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg12&nbsp;:=&nbsp;EmptyParam;<BR>&nbsp;&nbsp;vArg13&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg14&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg15&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg16&nbsp;:=&nbsp;EmptyParam;<BR>&nbsp;&nbsp;vArg17&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg18&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg19&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg20&nbsp;:=&nbsp;EmptyParam;<BR>&nbsp;&nbsp;vArg21&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg22&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg23&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg24&nbsp;:=&nbsp;EmptyParam;<BR>&nbsp;&nbsp;vArg25&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg26&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg27&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg28&nbsp;:=&nbsp;EmptyParam;<BR>&nbsp;&nbsp;vArg29&nbsp;:=&nbsp;EmptyParam;&nbsp;vArg30&nbsp;:=&nbsp;EmptyParam;<BR><BR>&nbsp;&nbsp;FExcelApplication.Visible[0]&nbsp;:=&nbsp;True;<BR>&nbsp;&nbsp;FExcelApplication.Connect;<BR>&nbsp;&nbsp;FExcelApplication.Caption&nbsp;:=&nbsp;'test1';<BR>&nbsp;&nbsp;FExcelApplication.Workbooks.Add('d:\1.xls',&nbsp;0);<BR>&nbsp;&nbsp;FExcelWorkbook.ConnectTo(FExcelApplication.ActiveWorkbook);<BR>&nbsp;&nbsp;FExcelWorksheet.ConnectTo(FExcelWorkbook.Activesheet&nbsp;as&nbsp;_WorkSheet);<BR><BR>&nbsp;&nbsp;V&nbsp;:=&nbsp;FExcelWorkbook.VBProject.VBComponents.Add(1);<BR>&nbsp;&nbsp;V.name&nbsp;:=&nbsp;'Module';<BR>&nbsp;//&nbsp;V.CodeModule.AddFromString('Public&nbsp;Sub&nbsp;test()&nbsp;'&nbsp;+&nbsp;#13&nbsp;+&nbsp;'msgbox("test")&nbsp;'&nbsp;+&nbsp;#13&nbsp;+&nbsp;'end&nbsp;sub');<BR>&nbsp;&nbsp;&nbsp;&nbsp;V.CodeModule.AddFromFile('d:\1.bas');<BR>&nbsp;{动态加载宏除了的几种方法:V.CodeModule.AddFromString<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;V.CodeModule.AddFromFile<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;V.CodeModule.InsertLines<BR>}<BR>&nbsp;//&nbsp;FExcelApplication.Visible[0]&nbsp;:=&nbsp;True;<BR>&nbsp;&nbsp;FExcelApplication.Run('abc',&nbsp;vArg1,&nbsp;vArg2,&nbsp;vArg3,&nbsp;vArg4,&nbsp;vArg5,&nbsp;vArg6,&nbsp;vArg7,&nbsp;vArg8,&nbsp;vArg9,&nbsp;vArg10,<BR>&nbsp;&nbsp;&nbsp;&nbsp;vArg11,&nbsp;vArg12,&nbsp;vArg13,&nbsp;vArg14,&nbsp;vArg15,&nbsp;vArg16,&nbsp;vArg17,&nbsp;vArg18,&nbsp;vArg19,&nbsp;vArg20,<BR>&nbsp;&nbsp;&nbsp;&nbsp;vArg21,&nbsp;vArg22,&nbsp;vArg23,&nbsp;vArg24,&nbsp;vArg25,&nbsp;vArg26,&nbsp;vArg27,&nbsp;vArg28,&nbsp;vArg29,&nbsp;vArg30);<BR><BR><BR>end;<BR><BR>===========<BR>注：<BR>1）、d:\1.xls&nbsp;为任意建的一个空excel文件<BR><BR>2）、d:\1.bas&nbsp;为用excel&nbsp;宏录制的一段代码，其中有一个过程&nbsp;<BR>abc(),宏代码如下（随便录的）<BR><BR>Sub&nbsp;abc()<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;Range("C4").Select<BR>&nbsp;&nbsp;&nbsp;&nbsp;ActiveCell.FormulaR1C1&nbsp;=&nbsp;"1111"<BR>&nbsp;&nbsp;&nbsp;&nbsp;Range("C4").Select<BR>&nbsp;&nbsp;&nbsp;&nbsp;Selection.AutoFill&nbsp;Destination:=Range("C4:C10"),&nbsp;Type:=xlFillDefault<BR>&nbsp;&nbsp;&nbsp;&nbsp;Range("C4:C10").Select<BR>&nbsp;&nbsp;&nbsp;&nbsp;Range("D4").Select<BR>&nbsp;&nbsp;&nbsp;&nbsp;ActiveCell.FormulaR1C1&nbsp;=&nbsp;"666"<BR>&nbsp;&nbsp;&nbsp;&nbsp;Range("D4").Select<BR>&nbsp;&nbsp;&nbsp;&nbsp;Selection.AutoFill&nbsp;Destination:=Range("D4:D10"),&nbsp;Type:=xlFillDefault<BR>&nbsp;&nbsp;&nbsp;&nbsp;Range("D4:D10").Select<BR>&nbsp;&nbsp;&nbsp;&nbsp;Range("C4:D10").Select<BR>&nbsp;&nbsp;&nbsp;&nbsp;With&nbsp;Selection.Interior<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.Pattern&nbsp;=&nbsp;xlSolid<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.PatternColorIndex&nbsp;=&nbsp;xlAutomatic<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.Color&nbsp;=&nbsp;65535<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.TintAndShade&nbsp;=&nbsp;0<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.PatternTintAndShade&nbsp;=&nbsp;0<BR>&nbsp;&nbsp;&nbsp;&nbsp;End&nbsp;With<BR>&nbsp;&nbsp;&nbsp;&nbsp;Range("D6").Select<BR>&nbsp;&nbsp;&nbsp;&nbsp;With&nbsp;Selection.Interior<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.Pattern&nbsp;=&nbsp;xlSolid<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.PatternColorIndex&nbsp;=&nbsp;xlAutomatic<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.Color&nbsp;=&nbsp;255<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.TintAndShade&nbsp;=&nbsp;0<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.PatternTintAndShade&nbsp;=&nbsp;0<BR>&nbsp;&nbsp;&nbsp;&nbsp;End&nbsp;With<BR>End&nbsp;Sub<BR><BR><BR>]]></description>
</item><item>
<title><![CDATA[word中运行vba 出现  运行时错误"1004"]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=51414</link>
<author>lxy7105</author>
<pubDate>2011/5/18 22:07:48</pubDate>
<description><![CDATA[我用word&nbsp;2010编了一个vba程序，在word&nbsp;2003下运行时出现<BR><BR>运行时错误"1004"<BR><BR>经过调试，最后发现，在word2010中支持的语句saveas2，在word2003出错，重新改为saveas语句，在word2003下程序正确运行。<BR><BR>经验是尽量使用低版本中的语法，因为大部分软件向下兼容的。<BR>]]></description>
</item><item>
<title><![CDATA[word也用正则表达式]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=51404</link>
<author>lxy7105</author>
<pubDate>2011/5/16 14:12:05</pubDate>
<description><![CDATA[word&nbsp;中的查找替换很强悍，能实现一些简单的正则表达式。<BR><BR>如将<BR>&nbsp;&nbsp;1.<BR>&nbsp;&nbsp;2.<BR>等开头的段落文字替换为<BR>&nbsp;&nbsp;[(1.)]<BR>&nbsp;&nbsp;&nbsp;[(2.)]<BR>在查找替换框中查找格内输入<BR>(&lt;[1-9]{1,2}[.,．])<BR>替换格内输入<BR>[(\1)]<BR>点选高级中的通配符，再点全部替换即可。<BR><BR>值得提醒的是查找范围中前后一定用小括号围起来，才能使用。<BR>]]></description>
</item><item>
<title><![CDATA[vba解决 ：邮件合并时打开文件不提示“打开此文档将运行下列SQL命令”]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=51401</link>
<author>lxy7105</author>
<pubDate>2011/5/15 10:59:22</pubDate>
<description><![CDATA[当然要在vba中加入如下代码，并在工具引用中加入对windows&nbsp;script&nbsp;host&nbsp;object&nbsp;modal的引用。<BR>下为函数<BR><BR>Sub&nbsp;不提示sql()<BR>&nbsp;&nbsp;&nbsp;&nbsp;Dim&nbsp;注册表主键&nbsp;As&nbsp;String<BR>&nbsp;&nbsp;&nbsp;&nbsp;Dim&nbsp;工程名称&nbsp;As&nbsp;String<BR>&nbsp;&nbsp;&nbsp;&nbsp;Dim&nbsp;注册表项&nbsp;As&nbsp;String<BR>&nbsp;&nbsp;&nbsp;&nbsp;Dim&nbsp;注册表键名&nbsp;As&nbsp;Variant<BR>&nbsp;&nbsp;&nbsp;&nbsp;Dim&nbsp;注册表键值&nbsp;As&nbsp;Variant<BR>&nbsp;&nbsp;&nbsp;&nbsp;Dim&nbsp;arr&nbsp;As&nbsp;Variant<BR>&nbsp;&nbsp;&nbsp;&nbsp;Dim&nbsp;ii&nbsp;As&nbsp;Integer<BR>&nbsp;&nbsp;&nbsp;&nbsp;Dim&nbsp;WSH&nbsp;As&nbsp;WshShell<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;Set&nbsp;WSH&nbsp;=&nbsp;CreateObject("WSCRIPT.SHELL")<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表主键&nbsp;=&nbsp;"HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Word\"<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表项&nbsp;=&nbsp;"Options"<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表键名&nbsp;=&nbsp;Array("SQLSecurityCheck")<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表键值&nbsp;=&nbsp;Array(0)<BR><BR>WSH.RegWrite&nbsp;注册表主键&nbsp;&amp;&nbsp;注册表项&nbsp;&amp;&nbsp;"\"&nbsp;&amp;&nbsp;注册表键名(ii),&nbsp;注册表键值(ii),&nbsp;"REG_DWORD"<BR><BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;Set&nbsp;WSH&nbsp;=&nbsp;CreateObject("WSCRIPT.SHELL")<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表主键&nbsp;=&nbsp;"HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Word\"<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表项&nbsp;=&nbsp;"Options"<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表键名&nbsp;=&nbsp;Array("SQLSecurityCheck")<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表键值&nbsp;=&nbsp;Array("0000000")<BR><BR>WSH.RegWrite&nbsp;注册表主键&nbsp;&amp;&nbsp;注册表项&nbsp;&amp;&nbsp;"\"&nbsp;&amp;&nbsp;注册表键名(ii),&nbsp;注册表键值(ii),&nbsp;"REG_DWORD"<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;Set&nbsp;WSH&nbsp;=&nbsp;CreateObject("WSCRIPT.SHELL")<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表主键&nbsp;=&nbsp;"HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Word\"<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表项&nbsp;=&nbsp;"Options"<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表键名&nbsp;=&nbsp;Array("SQLSecurityCheck")<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表键值&nbsp;=&nbsp;Array("0000000")<BR><BR>WSH.RegWrite&nbsp;注册表主键&nbsp;&amp;&nbsp;注册表项&nbsp;&amp;&nbsp;"\"&nbsp;&amp;&nbsp;注册表键名(ii),&nbsp;注册表键值(ii),&nbsp;"REG_DWORD"<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;Set&nbsp;WSH&nbsp;=&nbsp;CreateObject("WSCRIPT.SHELL")<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表主键&nbsp;=&nbsp;"HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\"<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表项&nbsp;=&nbsp;"Options"<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表键名&nbsp;=&nbsp;Array("SQLSecurityCheck")<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表键值&nbsp;=&nbsp;Array("0000000")<BR><BR>WSH.RegWrite&nbsp;注册表主键&nbsp;&amp;&nbsp;注册表项&nbsp;&amp;&nbsp;"\"&nbsp;&amp;&nbsp;注册表键名(ii),&nbsp;注册表键值(ii),&nbsp;"REG_DWORD"<BR><BR>&nbsp;&nbsp;Set&nbsp;WSH&nbsp;=&nbsp;CreateObject("WSCRIPT.SHELL")<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表主键&nbsp;=&nbsp;"HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word\"<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表项&nbsp;=&nbsp;"Options"<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表键名&nbsp;=&nbsp;Array("SQLSecurityCheck")<BR>&nbsp;&nbsp;&nbsp;&nbsp;注册表键值&nbsp;=&nbsp;Array("0000000")<BR><BR>WSH.RegWrite&nbsp;注册表主键&nbsp;&amp;&nbsp;注册表项&nbsp;&amp;&nbsp;"\"&nbsp;&amp;&nbsp;注册表键名(ii),&nbsp;注册表键值(ii),&nbsp;"REG_DWORD"<BR>End&nbsp;Sub]]></description>
</item><item>
<title><![CDATA[delphi 为word文档增加一个段落样式]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=51274</link>
<author>lxy7105</author>
<pubDate>2011/4/10 21:32:30</pubDate>
<description><![CDATA[下为程序中的一段，解决了为文档增加一个段落样式。这个段落样式的基础样式为“标题2”，标题字体、字号重设了，关键是设了自动编号的功能。<BR>procedure&nbsp;TForm1.titlestyle(wordapp:&nbsp;variant);<BR>begin<BR>&nbsp;&nbsp;try<BR>&nbsp;//&nbsp;&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Delete;<BR>&nbsp;&nbsp;except<BR>&nbsp;&nbsp;end;<BR><BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.Add(Name&nbsp;:=&nbsp;'自定标题',&nbsp;type&nbsp;:=&nbsp;wdStyleTypeParagraph);<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').AutomaticallyUpdate&nbsp;:=&nbsp;False;<BR><BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').AutomaticallyUpdate&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').BaseStyle&nbsp;:=&nbsp;'标题&nbsp;2&nbsp;';<BR><BR><BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.NameFarEast&nbsp;:=&nbsp;'&nbsp;+&nbsp;中文标题';<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.NameAscii&nbsp;:=&nbsp;'&nbsp;+&nbsp;西文标题';<BR>&nbsp;//&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.NameOther&nbsp;:=&nbsp;'&nbsp;+&nbsp;西文标题';<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.Name&nbsp;:=&nbsp;'&nbsp;+&nbsp;西文标题';<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.Size&nbsp;:=&nbsp;10.5;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.Bold&nbsp;:=&nbsp;True;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.Italic&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.Underline&nbsp;:=&nbsp;wdUnderlineNone;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.UnderlineColor&nbsp;:=&nbsp;wdColorAutomatic;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.StrikeThrough&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.DoubleStrikeThrough&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.Outline&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.Emboss&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.Shadow&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.Hidden&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.SmallCaps&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.AllCaps&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.Color&nbsp;:=&nbsp;wdColorAutomatic;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.Engrave&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.Superscript&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.Subscript&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.Scaling&nbsp;:=&nbsp;100;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.Kerning&nbsp;:=&nbsp;0;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.Animation&nbsp;:=&nbsp;wdAnimationNone;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.DisableCharacterSpaceGrid&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.EmphasisMark&nbsp;:=&nbsp;wdEmphasisMarkNone;<BR><BR><BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.LeftIndent&nbsp;:=&nbsp;CentimetersToPoints(0.74);<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.RightIndent&nbsp;:=&nbsp;CentimetersToPoints(0);<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.SpaceBefore&nbsp;:=&nbsp;6;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.SpaceBeforeAuto&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.SpaceAfter&nbsp;:=&nbsp;6;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.SpaceAfterAuto&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.LineSpacingRule&nbsp;:=&nbsp;wdLineSpace1pt5;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.Alignment&nbsp;:=&nbsp;wdAlignParagraphLeft;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.WidowControl&nbsp;:=&nbsp;True;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.KeepWithNext&nbsp;:=&nbsp;True;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.KeepTogether&nbsp;:=&nbsp;True;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.PageBreakBefore&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.NoLineNumber&nbsp;:=&nbsp;False;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.Hyphenation&nbsp;:=&nbsp;True;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.FirstLineIndent&nbsp;:=&nbsp;CentimetersToPoints(-0.74);<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.OutlineLevel&nbsp;:=&nbsp;wdOutlineLevel1;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.CharacterUnitLeftIndent&nbsp;:=&nbsp;0;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.CharacterUnitRightIndent&nbsp;:=&nbsp;0;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.CharacterUnitFirstLineIndent&nbsp;:=&nbsp;0;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.LineUnitBefore&nbsp;:=&nbsp;0;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.LineUnitAfter&nbsp;:=&nbsp;0;<BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').ParagraphFormat.BaseLineAlignment&nbsp;:=&nbsp;wdBaselineAlignAuto;<BR><BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').NoSpaceBetweenParagraphsOfSameStyle&nbsp;:=&nbsp;False;<BR><BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).NumberFormat&nbsp;:=&nbsp;'%1.';<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).TrailingCharacter&nbsp;:=&nbsp;wdTrailingTab;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).NumberStyle&nbsp;:=&nbsp;wdListNumberStyleArabic;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).NumberPosition&nbsp;:=&nbsp;CentimetersToPoints(0);<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Alignment&nbsp;:=&nbsp;wdListLevelAlignLeft;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).TextPosition&nbsp;:=&nbsp;CentimetersToPoints(0.74);<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).TabPosition&nbsp;:=&nbsp;wdUndefined;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).ResetOnHigher&nbsp;:=&nbsp;0;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).StartAt&nbsp;:=&nbsp;1;<BR><BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Font.Bold&nbsp;:=&nbsp;wdUndefined;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Font.Italic&nbsp;:=&nbsp;wdUndefined;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Font.StrikeThrough&nbsp;:=&nbsp;wdUndefined;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Font.Subscript&nbsp;:=&nbsp;wdUndefined;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Font.Superscript&nbsp;:=&nbsp;wdUndefined;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Font.Shadow&nbsp;:=&nbsp;wdUndefined;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Font.Outline&nbsp;:=&nbsp;wdUndefined;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Font.Emboss&nbsp;:=&nbsp;wdUndefined;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Font.Engrave&nbsp;:=&nbsp;wdUndefined;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Font.AllCaps&nbsp;:=&nbsp;wdUndefined;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Font.Hidden&nbsp;:=&nbsp;wdUndefined;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Font.Underline&nbsp;:=&nbsp;wdUndefined;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Font.Color&nbsp;:=&nbsp;wdUndefined;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Font.Size&nbsp;:=&nbsp;wdUndefined;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Font.Animation&nbsp;:=&nbsp;wdUndefined;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Font.DoubleStrikeThrough&nbsp;:=&nbsp;wdUndefined;<BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).Font.Name&nbsp;:=&nbsp;'';<BR><BR>&nbsp;//&nbsp;wordapp.ListGalleries.item(wdNumberGallery).LinkedStyle&nbsp;:=&nbsp;'自定标题';<BR><BR>&nbsp;&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').LinkToListTemplate(ListTemplate&nbsp;:=&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1),&nbsp;ListLevelNumber&nbsp;:=&nbsp;1);<BR>end;]]></description>
</item><item>
<title><![CDATA[delphi 增加一个类vba中的CentimetersToPoints函数]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=51273</link>
<author>lxy7105</author>
<pubDate>2011/4/10 21:29:55</pubDate>
<description><![CDATA[function&nbsp;TForm1.CentimetersToPoints(xCentimeters:&nbsp;real):&nbsp;Real;<BR>begin<BR>&nbsp;&nbsp;result&nbsp;:=&nbsp;xCentimeters&nbsp;*&nbsp;28.35;<BR>end;]]></description>
</item><item>
<title><![CDATA[delphi关闭原先已被打开的word文档的函数]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=51272</link>
<author>lxy7105</author>
<pubDate>2011/4/10 21:27:17</pubDate>
<description><![CDATA[procedure&nbsp;TForm1.closedoc(filename:&nbsp;string);<BR><BR>var<BR>&nbsp;&nbsp;H:&nbsp;THandle;<BR>&nbsp;&nbsp;P:&nbsp;DWORD;<BR>&nbsp;&nbsp;afile:&nbsp;string;<BR><BR>begin<BR>&nbsp;&nbsp;afile&nbsp;:=&nbsp;ExtractFileName(filename);<BR><BR>&nbsp;&nbsp;H&nbsp;:=&nbsp;FindWindow(nil,&nbsp;PChar(afile&nbsp;+&nbsp;'&nbsp;-&nbsp;Microsoft&nbsp;Word'));<BR><BR>&nbsp;&nbsp;if&nbsp;H&nbsp;&lt;&gt;&nbsp;0&nbsp;then<BR>&nbsp;&nbsp;begin<BR>&nbsp;&nbsp;&nbsp;&nbsp;GetWindowThreadProcessId(H,&nbsp;@P);<BR>&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;P&nbsp;&lt;&gt;&nbsp;0&nbsp;then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TerminateProcess(OpenProcess(PROCESS_TERMINATE,&nbsp;False,&nbsp;P),&nbsp;$FFFFFFFF);<BR>&nbsp;&nbsp;end;<BR>end;]]></description>
</item><item>
<title><![CDATA[delphi 对word编程的几个小体会]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=51271</link>
<author>lxy7105</author>
<pubDate>2011/4/10 21:24:02</pubDate>
<description><![CDATA[目前正在用delphi写一款excel表格转word文档的小软件，在写的过程中摸索到一些小技巧<BR><BR>1）、&nbsp;adoc.application.Selection.Borders.item(wdBorderVertical).LineStyle&nbsp;:=&nbsp;wdLineStyleDot;<BR><BR>比如原来的对象集Borders，就不能用borders(wdBorderVertical)表示其中的子对象，而应用Borders.item(wdBorderVertical)来表示。在delphi中的这个操作与vba中的是有明显区别的，与此类似的，还有如下<BR>&nbsp;wordapp.ActiveDocument.Styles.item('自定标题').Font.Bold&nbsp;:=&nbsp;True;<BR><BR>&nbsp;&nbsp;wordapp.ListGalleries.item(wdNumberGallery).ListTemplates.item(1).ListLevels.item(1).NumberFormat&nbsp;:=&nbsp;'%1.';<BR><BR>这里面的styles,ListGalleries,ListTemplates等等。<BR><BR>2）、wordapp.selection.style&nbsp;:=&nbsp;'标题1';<BR>这语句有两个点在关注，第一点：selection是word.application对象的子对象，而不是document对象的子对象。第二点，选定对象设置为某种样式，直接等于该样式名就可以了，而不用vba里面类似的语句。<BR><BR><BR>]]></description>
</item><item>
<title><![CDATA[无限制版软件注会考试练习软件下载]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=51005</link>
<author>lxy7105</author>
<pubDate>2011/2/17 17:52:52</pubDate>
<description><![CDATA[
<P>无限制版软件注会考试练习软件下载</P>
<P><A href="http://www.whzysoft.cn/download/注会考试练习系统安装.rar" target=_blank><FONT color=#006699>http://www.whzysoft.cn/download/注会考试练习系统安装.rar</FONT></A></P>
<P>不需注册码，不限制，如果你有word 版的题库请发给作者加入其中</P>
<P>lxy7105#126.com</P>
<P>为交流特申请一个群用于考友交流 qq群&nbsp;11137518</P>]]></description>
</item><item>
<title><![CDATA[delphi 取得xls文件中单个表的顺序号]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=50558</link>
<author>lxy7105</author>
<pubDate>2010/11/19 14:09:13</pubDate>
<description><![CDATA[function&nbsp;mb.opensheet(sheetname:&nbsp;string):&nbsp;integer;<BR>var&nbsp;i:&nbsp;integer;<BR>begin<BR>&nbsp;&nbsp;result&nbsp;:=&nbsp;-1;<BR>&nbsp;&nbsp;for&nbsp;i&nbsp;:=&nbsp;1&nbsp;to&nbsp;xlsapp.worksheets.count&nbsp;do<BR>&nbsp;&nbsp;begin<BR>&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;uppercase(trim(xlsapp.worksheets[i].name))&nbsp;=&nbsp;uppercase(trim(sheetname))&nbsp;then<BR>&nbsp;&nbsp;&nbsp;&nbsp;begin<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;result&nbsp;:=&nbsp;i;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;exit;<BR>&nbsp;&nbsp;&nbsp;&nbsp;end;<BR>&nbsp;&nbsp;end;<BR>end;<BR><BR>==<BR>下面是运用，<BR>&nbsp;&nbsp;sheetorder&nbsp;:=&nbsp;opensheet(mb_sheetname);<BR>&nbsp;&nbsp;if&nbsp;sheetorder&nbsp;=&nbsp;-1&nbsp;then<BR>&nbsp;&nbsp;begin<BR>&nbsp;&nbsp;&nbsp;&nbsp;showmessage('没有指定的表格，退出');<BR>&nbsp;&nbsp;&nbsp;&nbsp;exit;<BR>&nbsp;&nbsp;end;<BR>&nbsp;&nbsp;worksheet&nbsp;:=&nbsp;xlsapp.worksheet[i];<BR>&nbsp;&nbsp;for&nbsp;i&nbsp;:=&nbsp;1&nbsp;to&nbsp;worksheet.usedrange.rows.count&nbsp;do<BR>&nbsp;&nbsp;&nbsp;&nbsp;for&nbsp;j&nbsp;:=&nbsp;1&nbsp;to&nbsp;worksheet.usedrange.cols.count&nbsp;do<BR>&nbsp;&nbsp;&nbsp;&nbsp;begin<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;showmessage(INTTOSTR(worksheet.cells(i,&nbsp;j).interior.color));&nbsp;&nbsp;//与下面一行是两种单元格的表式方法<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;worksheet.cells(i,&nbsp;j).interior.color&nbsp;=&nbsp;5296274&nbsp;then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;begin<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;showmessage('ok');<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;end;<BR>&nbsp;&nbsp;&nbsp;&nbsp;end;]]></description>
</item><item>
<title><![CDATA[导入Excel表时,提示＂找不到可安装的ISAM＂问题的解决方法]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=50539</link>
<author>lxy7105</author>
<pubDate>2010/11/16 13:28:52</pubDate>
<description><![CDATA[问：安装过了Microsoft&nbsp;Office&nbsp;2003&nbsp;和2007,都很好用。就是有时，一些软件需要导入EXCEL的文件时，会提示出现：<BR><BR>　　尝试连接Microsoft&nbsp;Office&nbsp;Excel数据失败!<BR><BR>　　【详细情况】<BR><BR>　　找不到可安装的ISAM<BR><BR>　　出现以上的情况，应该怎么解决呢?<BR><BR>　　答：只需注册&nbsp;Excel&nbsp;ISAM即可<BR><BR>　　在“运行”对话框中输入回车即可:<BR><BR>　　Regsvr32&nbsp;c:\WINDOWS\system32\msexcl40.dll]]></description>
</item><item>
<title><![CDATA[改变word域中的数字的格式]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=50535</link>
<author>lxy7105</author>
<pubDate>2010/11/15 14:47:16</pubDate>
<description><![CDATA[我做一个函证的模板时，链接的是一个excel的表格，里面的小数到word中的时候，会出现小数位后非常多的位数，而不是按习惯取小数点后两位，并按千分位进行显示<BR><BR>此时我在word中需按格式显示的域加入相应的格式符后显示正常了，<BR><BR>按shift+f9显示当前域的代码，为{MERGEFIELD&nbsp;资产类金额_&nbsp;}&nbsp;,修改后的代码是MERGEFIELD&nbsp;资产类金额_&nbsp;&nbsp;\#&nbsp;"#,###.00"<BR><BR>]]></description>
</item><item>
<title><![CDATA[vba中文件名常用函数]]></title>
<link>http://blogger.org.cn/blog/more.asp?name=lxy7105&amp;id=50480</link>
<author>lxy7105</author>
<pubDate>2010/11/7 20:19:19</pubDate>
<description><![CDATA[Function&nbsp;GetFileName(strFileName&nbsp;As&nbsp;Variant)&nbsp;As&nbsp;String<BR>'得到无路径的文件名，但含扩展名<BR>&nbsp;&nbsp;&nbsp;&nbsp;Dim&nbsp;i&nbsp;As&nbsp;Integer<BR>&nbsp;&nbsp;&nbsp;&nbsp;For&nbsp;i&nbsp;=&nbsp;Len(strFileName)&nbsp;To&nbsp;1&nbsp;Step&nbsp;-1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If&nbsp;Mid$(strFileName,&nbsp;i,&nbsp;1)&nbsp;=&nbsp;"\"&nbsp;Then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;GetFileName&nbsp;=&nbsp;Mid$(strFileName,&nbsp;i&nbsp;+&nbsp;1)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Exit&nbsp;Function<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;End&nbsp;If<BR>&nbsp;&nbsp;&nbsp;&nbsp;Next&nbsp;i<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;GetFileName&nbsp;=&nbsp;strFileName<BR><BR>End&nbsp;Function<BR><BR>Function&nbsp;GetFileName_no_ext(strFileName&nbsp;As&nbsp;Variant)&nbsp;As&nbsp;String<BR>'得到无扩展名，无路径的文件名<BR>&nbsp;&nbsp;&nbsp;&nbsp;Dim&nbsp;filename_noext&nbsp;As&nbsp;String<BR>&nbsp;&nbsp;&nbsp;&nbsp;Dim&nbsp;pos1&nbsp;As&nbsp;Integer<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;filename_noext&nbsp;=&nbsp;GetFileName(strFileName)<BR>&nbsp;&nbsp;&nbsp;&nbsp;pos1&nbsp;=&nbsp;InStr(filename_noext,&nbsp;".")<BR>&nbsp;&nbsp;&nbsp;&nbsp;If&nbsp;pos1&nbsp;&gt;&nbsp;0&nbsp;Then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;filename_noext&nbsp;=&nbsp;Mid(filename_noext,&nbsp;1,&nbsp;pos1&nbsp;-&nbsp;1)<BR>&nbsp;&nbsp;&nbsp;&nbsp;End&nbsp;If<BR>&nbsp;&nbsp;&nbsp;&nbsp;GetFileName_no_ext&nbsp;=&nbsp;filename_noext<BR><BR>End&nbsp;Function<BR><BR><BR><BR>Function&nbsp;GetFilePath(strFileName)&nbsp;As&nbsp;String<BR>'得到文件路径名<BR>&nbsp;&nbsp;&nbsp;&nbsp;Dim&nbsp;i&nbsp;As&nbsp;Integer<BR><BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;For&nbsp;i&nbsp;=&nbsp;Len(strFileName)&nbsp;To&nbsp;1&nbsp;Step&nbsp;-1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If&nbsp;Mid$(strFileName,&nbsp;i,&nbsp;1)&nbsp;=&nbsp;"\"&nbsp;Then<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;GetFilePath&nbsp;=&nbsp;Mid$(strFileName,&nbsp;1,&nbsp;i)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Exit&nbsp;Function<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;End&nbsp;If<BR>&nbsp;&nbsp;&nbsp;&nbsp;Next&nbsp;i<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;GetFilePath&nbsp;=&nbsp;strFileName<BR><BR>End&nbsp;Function<BR>]]></description>
</item>
</channel>
</rss>