stewart1
Board Regular
- Joined
- Feb 25, 2010
- Messages
- 66
Evening to all.
I've embedded a word document which I managed to cobble code together to open.
I'm a bit stuck on copying the cell contents to it via vba. Keeping all the cell formatting. Once the word doc opens, no more code is recorded.
Can anyone give me any ideas please?
As always really appreciated you taking the time to read.
Stu
I've embedded a word document which I managed to cobble code together to open.
VBA Code:
Sub Macro4()
'
' Macro4 Macro
'
'
Dim wDoc As Object 'Word.Document
With ActiveSheet
ActiveCell.Copy
Set o = .OLEObjects("Object 5")
o.Verb xlVerbOpen
ActiveSheet.Shapes.Range(Array("Object 5")).Select
Selection.Verb Verb:=xlPrimary
End With
End Sub
I'm a bit stuck on copying the cell contents to it via vba. Keeping all the cell formatting. Once the word doc opens, no more code is recorded.
Can anyone give me any ideas please?
As always really appreciated you taking the time to read.
Stu