Setting Column Width In Every Excel Table Embeded In Word

Hi,

I have several Excel tables in a word document. I want to make Column "B" in every table to have a Width of "25".

How can I do that through VBA. I can't seem to find how to do it.

Thanks,

Mark

Originally Posted by snb

Did you record a macro in Word while adjusting the columns ?

I had Tried, but it wasn't working for some reason. I couldn't select the tables

I tried to upload the file but I am getting an error from ExcelForum.

Basically, I will have about 200 small Excel tables embedded into the document. When I finished adding the tables, I want to be able to adjust certain properties (column widths, fonts, etc) without opening each one seperately.

I thought it would be an easy "With" of "For" statement but they are not working.


Thanks for any help,


Mark

Ok, here it is.

I place the first one using, Insert>Table>Excel Spreadsheet

Then I just copied and modified the rest.


thanks again for your help.

Mark

Since no one has an answer for this particular question, does anyone know the easiest want to move all of these tables to a single excel worksheet? Sorry if this question should be in a new thread, if so, I will move it.


Mark

thanks, ill look into it further

I couldn't get it to work. I tried using "shapes" (that is what Excel calls an embedded excel table when recording a macro). But when trying to use "...shapes.count" is comes up with "0".