 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / March 2006How to adjust size line when copying data from excel to word
I have copy and paste a table from excel to word and all lines are define as 1/2 point lenght. I link the data table using LINK excel8 function but I would like that all line 1/2 point be convert as 1/4 point. Does anyone know how to do that ? 1/4 point doesn't exist in excel ? Thanks.  SignatureAlex St-Pierre Hi Alex, > I have copy and paste a table from excel to word and all lines are define as > 1/2 point lenght. I link the data table using LINK excel8 function but I > would like that all line 1/2 point be convert as 1/4 point. Does anyone know > how to do that ? > 1/4 point doesn't exist in excel ? This approach might work, but I'm not sure... 1. Try using the \r or \h function in the LINK field (this would be the equivalent of Paste Special in RTF or HTML format). This will insert the Excel table with Word table properties. 2. Make sure there's a \* MergeFormat switch in the LINK field (to preserve formatting you apply to the table while in Word). 3. Now select the table and change the border formatting. In order to test whether this works, click in the table and press F9 to force the update. If the borders don't change back, you're in business. 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 :-) Hi Cindy, Thanks for the answer. The problem I have is that I can't let the \* MergeFormat because my table is very complicated in excel. Example of my table: Item1 Item2 Border between Item2 and Total1 Total1 Item3 Item4 .. If I add a line between Item 2 and Total in excel, the Underline will stay just after Item2 (should be after the new item). Word cannot know that an Item as been added in the table to adjust Border. An other solution should be to use a line as - - - - - - - - in excel.. Word will recognize it as 1/4. This solution is not very stable. RTF format need more stability but for the data, it is the only format (with link) that preserve the excel column width. SignatureAlex St-Pierre > Hi Alex, > [quoted text clipped - 25 lines] > This reply is posted in the Newsgroup; please post any follow question or reply > in the newsgroup and not by e-mail :-) > The problem I have is that I can't let the \* MergeFormat because my table > is very complicated in excel. Current follow-up on this issue is in the word.docmanagement newsgroup. Cindy Meister |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.