Hello,

I have an excel program what loads and analyses tens of thousands of cells and condenses the important information into a table formatted as "Table1" which is in the range "A1:B17" I couldnt get the "PasteExcelTable" method to work. What I am attempting to do now is open a word template I created that has the company logo, headers, footers and appropriate bookmarks for the specific location that the data needs to be on the report. Below is my code:
Please Login or Register  to view this content.
The problem I am having is that when it attempts to paste the table range and continue the code word crashes. I am assuming it crashes, however it does create the file and save it in the specified location. When the newly saved word file is opened it says that the file cannot be opened because an error occurred but it does not tell me what the error is so I do not know how to solve it. For now I have hard coded the paths because I was trying a few different locations. I had originally thought it was caused by the files being on a network drive so I moved them to a local folder on my desktop. This resulted in the same problem. I tried to comment what I intend each section to do, to help clarify what my flow was intended to be.