Hi,
I am very new to Excel VBA, I am hoping I can set a macro to export Excel tables to Word.
In Excel, I have set of tables on each tab, each table is specifically named. All table has the same width, we want to maintain the format in Excel to Word.
In Word, I have set of bookmarks, the idea is that each bookmark has a name corresponding to the Excel table (i.e. Bookmark named 1 where table name is also 1).
What we would like to achieve is to export tables to where the bookmarks are located in Word.
Can anyone help me set up a macro?
Thank you.
I am very new to Excel VBA, I am hoping I can set a macro to export Excel tables to Word.
In Excel, I have set of tables on each tab, each table is specifically named. All table has the same width, we want to maintain the format in Excel to Word.
In Word, I have set of bookmarks, the idea is that each bookmark has a name corresponding to the Excel table (i.e. Bookmark named 1 where table name is also 1).
What we would like to achieve is to export tables to where the bookmarks are located in Word.
Can anyone help me set up a macro?
Thank you.