
Originally Posted by
josephemery
Hello Everybody
I am writing the code for the program and I am getting a run time error of 438- object doesn?t support this method or property. What it look likes is that Excel VBA doesn?t recognizes ActiveDocument command. I am not sure, but here my code. If it helpfully I am using Office 2003. ExcelInfo can be either string or number depends on the info.
[VBA]
Dim WdApps As Object
Set WdApps = CreateObject("Word.Application")
WdApps.documents.Open "path"
WdApps.Visible = True
Set Activedocument = WdApps
'put the excel info the word doc
Set ExcelInfo = Activedocuments.Bookmarks("name").Range
[/VBA]
Any help given will be greatly appreciated. Thanks
Joseph