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 » Formatting Long Documents
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Word question regarding TOC (newbie question)...



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2004, 01:56 PM
Herman Geerlings
external usenet poster
 
Posts: n/a
Default Word question regarding TOC (newbie question)...

Dear all,

I have a question regarding the use of the field {TOC}.

I have a Word Template with amongs others the following fieldcode
{TOC \t \n \l 2-2}. This fieldcode is triggered via (Lotusscript/VBA)
code but stops at this part of the code:
==========part of code ==================
appWD.Selection.Style=[value]
==========part of code ==================

This works fine under Office '97 English but not in other versions of
Office.
In Dutch I get for instance the message "Microsoft Word: Er bestaat
geen item met de opgegeven naam." meaning "There is no item with the
given name".

Questions:
-Is it possible that other office versions are not compatible with
this part of the code?
-Or am I looking in the wrong direction?

I know that the information provided is brief. But maybe someone can
give me a clue where to look for an answer.

Regards,

Herman Geerlings
  #2  
Old June 1st, 2004, 04:54 PM
Cindy M -WordMVP-
external usenet poster
 
Posts: n/a
Default Word question regarding TOC (newbie question)...

Hi Herman,

I'm having difficulty understanding why the problem in your VBA code
could possibly have anything to do with the TOC?

What kinds of things could [value] be?

As a general rule
1. You should refer to built-in styles using a wd constant
2. Word checks for styles by the style name, as it appears in the
document, and this comparison is case-sensitive
3. If a document is opened in a different language version, the
built-in style names will change to that local language (why one should
use the wd constants)

So, my best guess to why you'd be getting the error message is that
[value] isn't in the document...

I have a question regarding the use of the field {TOC}.

I have a Word Template with amongs others the following fieldcode
{TOC \t \n \l 2-2}. This fieldcode is triggered via (Lotusscript/VBA)
code but stops at this part of the code:
==========part of code ==================
appWD.Selection.Style=[value]
==========part of code ==================

This works fine under Office '97 English but not in other versions of
Office.
In Dutch I get for instance the message "Microsoft Word: Er bestaat
geen item met de opgegeven naam." meaning "There is no item with the
given name".

Questions:
-Is it possible that other office versions are not compatible with
this part of the code?
-Or am I looking in the wrong direction?

I know that the information provided is brief. But maybe someone can
give me a clue where to look for an answer.


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
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  
Old June 2nd, 2004, 08:29 AM
Herman Geerlings
external usenet poster
 
Posts: n/a
Default Word question regarding TOC (newbie question)...

Hi Cindy,

thank you for your reply.
I will explain in more detail what the situation is.
I am administring and further developing on a Lotus/Domino application
which has amongst others a module which intergrates with Microsoft
word.

This integration module fills in fields in a Word template with data
from Notes fields and also the field {TOC}.

The application was tested and everything worked well (under Word
English).
However under a Dutch version the integration module does not work
well.
I looked in debug mode and the Notes module stopped at

==appWD.Selection.style=strSpecialFormat==

and in the started Word document at the field {TOC \t\n \l 2-2}.

So to answer one of your questions, that is why my focus was and is on
this field.

I looked up in the Word help what the switches meant;
\l \n has something to do with the level of the table of contents and
the
\t has something to do with the style.

What I presume is that in different languages, the values of the
switches are different. Maybe you differ in opinion.

What is more strange is that I can work and generate a word report on
my english verion on the same database and the others cannot generate
a word report in their dutch version.

Questions:
-Are you familiair if in different languages the allowable values for
the switches are different?
-What is a wd constant?


Regards,

Herman Geerlings

p.s. The value that is applied to appWD.Selection.style is "TOC 2", a
string.
p.p.s. I am very open for out of the box thinking. So any suggestion
for this problem, even if you think it is a wild guess is welcome.


Cindy M -WordMVP- wrote in message news:VA.000099a0.002e2f3e@speedy...
Hi Herman,

I'm having difficulty understanding why the problem in your VBA code
could possibly have anything to do with the TOC?

What kinds of things could [value] be?

As a general rule
1. You should refer to built-in styles using a wd constant
2. Word checks for styles by the style name, as it appears in the
document, and this comparison is case-sensitive
3. If a document is opened in a different language version, the
built-in style names will change to that local language (why one should
use the wd constants)

So, my best guess to why you'd be getting the error message is that
[value] isn't in the document...

  #4  
Old June 2nd, 2004, 01:42 PM
Cindy M -WordMVP-
external usenet poster
 
Posts: n/a
Default Word question regarding TOC (newbie question)...

Hi Herman,

The value that is applied to appWD.Selection.style is "TOC 2", a
string.

Chances are, the problem is that, in the Dutch language version the
style name is not TOC 2, but something else (in German - the second
language I deal with regularly - it's Verzeichnis 2, for example). This
would cause the VBA to stop in its tracks, with the error message you
quoted :-)

As I mentioned in my first reply, Word converts the names of the styles
built into it according to the user's language interface.

For this reason, Microsoft provides the wdStyle constants (long data
types) in VBA. If you would pass [value] as a Variant, then you could
use wdStyleTOC2 instead of "TOC 2" and every language version will
recognize it.

I am administring and further developing on a Lotus/Domino application
which has amongst others a module which intergrates with Microsoft
word.

This integration module fills in fields in a Word template with data
from Notes fields and also the field {TOC}.

The application was tested and everything worked well (under Word
English).
However under a Dutch version the integration module does not work
well.
I looked in debug mode and the Notes module stopped at

==appWD.Selection.style=strSpecialFormat==

and in the started Word document at the field {TOC \t\n \l 2-2}.


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
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 :-)

  #5  
Old June 4th, 2004, 03:12 PM
Herman Geerlings
external usenet poster
 
Posts: n/a
Default Word question regarding TOC (newbie question)...

Hi Cindy,

it worked. I just changed TOC to Inhopg (Dutch) in certain values and
the Word Report was generated.
Now to solve it for our Spanish clients.

In the long run, the code will be made language independent.

Regards,

Herman Geerlings


Cindy M -WordMVP- wrote in message news:VA.000099ac.0043b4c3@speedy...
Hi Herman,

The value that is applied to appWD.Selection.style is "TOC 2", a
string.

Chances are, the problem is that, in the Dutch language version the
style name is not TOC 2, but something else (in German - the second
language I deal with regularly - it's Verzeichnis 2, for example). This
would cause the VBA to stop in its tracks, with the error message you
quoted :-)

 




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


All times are GMT +1. The time now is 03:06 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.