Opening word document from excel 2013
Hi, I'd like to open a word document and export data to it. I used to be able to do this in Excel 2003 (having been away for a while). In Excel 2013 this is no longer possible.
This is / was my code:
Sub Rapport_Xl_to_Word()
Dim Navn1, Navn2 As String
Dim dato As Date
'Dim wordapp As New Word.Application
Set wordapp = CreateObject("Word.Application")
'dato = Format(Now, "dd-mm-yyyy")
With wordapp
.Visible = True
.Documents.Open Filename:="C:\Desktop\Økonomirapport.docx"
..........
End With
End Sub
Where is the problem?
Thanks for any help provided!
|