如何将excel与word连通

 

 

1.前期绑定

工具---引用---Microsoft Word14.0 Object Library

dim wdapp as Word.Application

dim wdoc as document

set wdapp=new word.application

set wdoc=wdapp.documents.open("路径\word文件名.docx")

wdapp.visible=true  '显示文档

set wdapp =nothing '释放内存

set wdoc=nothing '释放内存

 

2.后期绑定

dim wdapp as object,wdoc as object

set wdapp=createobject("word.application")

set wdoc=wdapp.document.open("路径\文件名.docx")

 

3.