A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Heading Rows Repeat / Includetext - XML -XSL



 
 
Thread Tools Display Modes
  #11  
Old May 3rd, 2006, 01:25 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default Heading Rows Repeat / Includetext - XML -XSL

Hi =?Utf-8?B?Um9iZXJ0?=,

I think they said something to the effect of it being recognized as a
product "limitation", and that they knew it should be fixed, and that they
have had requests for it to be fixed, but that the demand wasn't high enough
to justify adding it to their fix/improvements list.

Ahhh. OK. I'll put that on my "nag" list g

Cindy Meister

  #12  
Old May 3rd, 2006, 01:25 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default Heading Rows Repeat / Includetext - XML -XSL

Hi =?Utf-8?B?UGV0ZXIgQmVyZw==?=,

I have tryed your suggestion, but receives an error saying: "Cannot access
individual rows in this collection because the table has vertically merged
cells"?

"Vertically merged cells" means that not every row / column has the same
number of cells (some have been selected and merged into a single cell).

Hmmm. Since you can set the HeaderRows in the user interface, it ought to be
possible using a macro. We just have to out-smart Word...

See if this does the job:

Sub SetHeaderRowsWithMergedCells()
Dim tbl As Word.Table

For Each tbl In ActiveDocument.Tables
tbl.Select
Selection.Cells(1).Select
Selection.Expand wdRow
Selection.Rows.HeadingFormat = True
Next
End Sub


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 :-)

  #13  
Old May 5th, 2006, 09:41 AM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default Heading Rows Repeat / Includetext - XML -XSL

Thank you, Cindy. You solved my problem! I am very impressed :-)

Just one thing further, I have search for a book describing this sort of
problems and more generally VBA in Word and Excel down to objects and
methods, do you have a good one, you use yourself?

Best regards, Peter

"Cindy M -WordMVP-" wrote:

Hi =?Utf-8?B?UGV0ZXIgQmVyZw==?=,

I have tryed your suggestion, but receives an error saying: "Cannot access
individual rows in this collection because the table has vertically merged
cells"?

"Vertically merged cells" means that not every row / column has the same
number of cells (some have been selected and merged into a single cell).

Hmmm. Since you can set the HeaderRows in the user interface, it ought to be
possible using a macro. We just have to out-smart Word...

See if this does the job:

Sub SetHeaderRowsWithMergedCells()
Dim tbl As Word.Table

For Each tbl In ActiveDocument.Tables
tbl.Select
Selection.Cells(1).Select
Selection.Expand wdRow
Selection.Rows.HeadingFormat = True
Next
End Sub


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 :-)


  #14  
Old May 5th, 2006, 02:08 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default Heading Rows Repeat / Includetext - XML -XSL

Hi =?Utf-8?B?UGV0ZXIgQmVyZw==?=,

I have search for a book describing this sort of
problems and more generally VBA in Word and Excel down to objects and
methods, do you have a good one, you use yourself?

This isn't very modest... Besides Word's VBA Help files, I mostly use
the book I wrote together with three other MVPs :-) It's in German, from
MS Press: Word-Programmierung, das Handbuch.

For the English-speaking people, I usually recommend the Word
2000 VBA Programmer's Reference from WROX.

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 :-)

  #15  
Old May 5th, 2006, 07:15 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default Heading Rows Repeat / Includetext - XML -XSL

Thank you again !

"Cindy M -WordMVP-" wrote:

Hi =?Utf-8?B?UGV0ZXIgQmVyZw==?=,

I have search for a book describing this sort of
problems and more generally VBA in Word and Excel down to objects and
methods, do you have a good one, you use yourself?

This isn't very modest... Besides Word's VBA Help files, I mostly use
the book I wrote together with three other MVPs :-) It's in German, from
MS Press: Word-Programmierung, das Handbuch.

For the English-speaking people, I usually recommend the Word
2000 VBA Programmer's Reference from WROX.

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
repeat heading rows in tables gailw Tables 0 March 23rd, 2006 10:04 PM
how to repeat rows at the bottom while using the rows repeat at to Rows to repeat at the bottom Setting up and Configuration 1 August 31st, 2005 02:06 PM
Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec unibaby General Discussion 2 August 24th, 2005 04:29 PM
Chapter Headings "continued" db Formatting Long Documents 2 November 5th, 2004 10:34 PM
still need help, repeat row as heading not working suzanne Tables 11 May 17th, 2004 08:31 AM


All times are GMT +1. The time now is 09:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.