-
Excel to Word template
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 Activedocuments = WdApps
'put the excel info the word doc
Set ExcelInfo = Activedocuments.Bookmarks("name").Range
[/VBA]
Any help given will be greatly appreciated. Thanks
Joseph
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules