Hello,
I'm trying to push my excel data to a word report. I've copied this code from another source (in the VBA Module attached), but I'm not sure where I have gone wrong - is it in the file name, or the file location name? It keeps coming back with an error and won't open up the Word Report. For this exercise I've uploaded the report as a normal word document, I've saved it as a template in my own files, but it this site wouldn't allow me to upload as a template file.
I've got the bookmarks in word the same as the range in excel.
Can someone help me please?
Pippi
NCR New Database - Test.xlsm
NCR Report for Register v1.1.docx
And to give credit to the website that I pilfered the code from: http://www.vbaexpress.com/kb/getarticle.php?kb_id=381
Bookmarks