PDA

View Full Version : Word Table formatting from excel vba



rohitchitre
01-02-2013, 06:58 AM
Hello,

I have exported a table from word to excel. Now I need to format the table as per user's requirement. I am not able to format the table borders from excel vba.
The format needs to be as per the attached file.
Can anyone help?

Thanks in advance.

Kenneth Hobs
01-02-2013, 01:46 PM
http://www.mrexcel.com/forum/excel-questions/382541-importing-word-document-data-excel.html

rohitchitre
01-03-2013, 12:18 AM
Thanks but this thread talk about importing word table into excel file. I want to format a word table from excel VBA.

Kenneth Hobs
01-03-2013, 08:02 AM
I am not sure how much macro code can be recorded but have you tried that?

These threads are more about adding the tables with data and not so much about formatting of the table but you might gleam some tips from them.

'Add Table to MSWord
' http://vbaexpress.com/forum/showthread.php?t=23975
' http://vbaexpress.com/forum/showthread.php?p=168731