Exporting to a Word Template

  • Hi All. I am relatively new to VBA coding and am trying to export a table (Column) to a word document, this part I can do successfully, and save it to a specified location with a name.

    What I would like to be able to do is when exporting the file is to have a specific template with headers and footers to open so the report is branded.

    The area below is the part giving me issues and in my VBE is showing up red and giving me a syntax error.

    Hope that someone could help me out here, it would be very much appreciated.

    Many Thanks,


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!