If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automatically Formatting column widths
So here is my situation:
I have a table with 2 columns and an unknown number of rows. I will be exporting from another program into a Word document that contains this Word table. I want to force the left column to span from leftmost edge of the page (0.2" exactly) to 0.75". I then want to force the right column to span from 0.75" to the right most edge of the page (0.75" from the right which is about 7.2"). Can I use AutoFormat to do this? Is there a better way to handle this? Say, templates perhaps? Can you please give me some input on how to get Autoformat to do this? Otherwise, can you direct me to information where I can learn more. Thanks for any help! Mike |
#2
|
|||
|
|||
Automatically Formatting column widths
Hi Mike,
I'm not sure I understand the problem. You're inserting a table, and it should have the given settings. These are made in Table/Table Properties, in the Columns tab. But I don't understand what that has to do with exporting from another program into the document that contains this table? I have a table with 2 columns and an unknown number of rows. I will be exporting from another program into a Word document that contains this Word table. I want to force the left column to span from leftmost edge of the page (0.2" exactly) to 0.75". I then want to force the right column to span from 0.75" to the right most edge of the page (0.75" from the right which is about 7.2"). Can I use AutoFormat to do this? Is there a better way to handle this? Say, templates perhaps? Can you please give me some input on how to get Autoformat to do this? Otherwise, can you direct me to information where I can learn more. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#3
|
|||
|
|||
Automatically Formatting column widths
Cindy,
The program is exporting the information into an MS word table. Since the export process creates the table, I have no way to define the column widths at the time of creation. Rather, what I need to be able to to is to just size the columns of an existing table at the click of a button (I dont want the user to go through multiple steps to format this table. Just a few clicks and voila). Will the Table Autoformat work for this? Mike "Cindy M -WordMVP-" wrote: Hi Mike, I'm not sure I understand the problem. You're inserting a table, and it should have the given settings. These are made in Table/Table Properties, in the Columns tab. But I don't understand what that has to do with exporting from another program into the document that contains this table? I have a table with 2 columns and an unknown number of rows. I will be exporting from another program into a Word document that contains this Word table. I want to force the left column to span from leftmost edge of the page (0.2" exactly) to 0.75". I then want to force the right column to span from 0.75" to the right most edge of the page (0.75" from the right which is about 7.2"). Can I use AutoFormat to do this? Is there a better way to handle this? Say, templates perhaps? Can you please give me some input on how to get Autoformat to do this? Otherwise, can you direct me to information where I can learn more. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#4
|
|||
|
|||
Automatically Formatting column widths
Hi =?Utf-8?B?YmF1ZXIxNzJ1dw==?=,
The program is exporting the information into an MS word table. Since the export process creates the table, I have no way to define the column widths at the time of creation. Rather, what I need to be able to to is to just size the columns of an existing table at the click of a button (I dont want the user to go through multiple steps to format this table. Just a few clicks and voila). Will the Table Autoformat work for this? No, TableAutoFormat won't give you anything for setting column widths. If this is being automated, the automation COULD set the widths, of course. $ Other than that, you'd need to provide the facility for the user. I have trouble imagining a button IN the table, although you could certainly do that (macrobutton field or ActiveX control). I'd be more inclined to provide a custom toolbar with a button to pop up an InputBox or whatever you deem most appropriate. Or you could even have it bring up Word's built-in dialog box, if that's what you'd prefer. Another possibility would be to use Events, so that you really do capture the user "clicking in the table". (WindowSelectionChange), but you'd have to really think through how/when you'd want it to fire. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to change column letters to correct ones in many formulas automatically? | Dmitry Kopnichev | Links and Linking | 7 | October 13th, 2005 09:52 PM |
How to change column letters to correct ones in many formulas automatically? | Dmitry Kopnichev | Worksheet Functions | 7 | October 13th, 2005 09:52 PM |
Lookup Table Dilemma | Karen | Worksheet Functions | 2 | June 10th, 2005 08:22 PM |
Conditional formatting applicable to entire column | jackalx | Worksheet Functions | 1 | May 26th, 2005 05:20 PM |
resizing column widths | tndmrx | Tables | 1 | September 1st, 2004 10:47 PM |