Dear all,
I am completely new to VBA programming but need a script to export data from an excel sheet automatically to a word template (on Mac!). I thought to start as simple as I can and wrote the script below. For some reason I managed to make the script work only once (i.e. the "Name", "Age", "Colour" and "Status" data from excel was copied onto the correct locations of the word template after which an error occurred). Since then, however, I keep getting a run-time error (Run-time error '-2146959355 (80080005)': Automation error) on the line "Set WordApp = CreateObject("Word.Application")". Anybody has any ideas on what could cause this error? Thanks in advance for taking a look!
Joost
----------------
Bookmarks