Problem with styles in automation of Word creation

**RagonichaFulva** · 03-02-2012, 08:59 AM

Hello,

I have created a code that automates the creation of a Word Document when I send to it two arrays with data.

The code is the following:

Please Login or Register  to view this content.

Everything works OK except for the part where this code is executed:

Please Login or Register  to view this content.

If I write it for instance, beneath the part:

Please Login or Register  to view this content.

The Header 1 Style appears correctly.

"str" is always a string.

I have tried including:

Please Login or Register  to view this content.

and it doesn't solve the problem either.

Apart from that, every second time I execute the code from excel, I have a server errors, as if the object was still existing, but actually, I close it in the end with this code, so I don't guess where the problem is:

Please Login or Register  to view this content.

I would much appreciate your assistance.

**snb** · 03-02-2012, 09:13 AM

Do not use VBA to format a Word document.
Make a Word template of the report, including all the formatting.
Use Docvariables to transfer data from Excel to the Worddocument.

**RagonichaFulva** · 03-02-2012, 10:03 AM

Do you mean to use bookmarks?

Can you address me to any url where I could learn about working this way?

I have searched for Doc variables, VBA, Excel, Word and I don't obtain clear references.

Thanks for your help.

**RagonichaFulva** · 03-02-2012, 10:11 AM

I found this:

http://books.google.co.uk/books?id=V...page&q&f=false

Is it the solution you are suggesting?

**RagonichaFulva** · 03-02-2012, 11:04 AM

I have searched through teh forum and found:

http://www.excelforum.com/excel-prog...in-fields.html
http://www.excelforum.com/word-forma...ith-excel.html

But it seems as this method is very rigid: 1 docvariable -> 1 value

It means that the number of elements has to be always the same.

**snb** · 03-02-2012, 11:18 AM

Save both files in the same directory.
Open the Excel file.
Use the macro in the Excel file.

**RagonichaFulva** · 03-02-2012, 12:02 PM

Hello snb,

First of all, thank you for your code and for your help. I had done a code of my own based on the threads I linked (some of them you had answered yourself).

I have downloaded your code and tried to test it, but it drawed an error (it didn't find the file/class name). I used a replace function to change "\\" into "\" and with both files open (with the word file closed it didn't work) it worked.

What I wonder is that if I need the following structure:

Please Login or Register  to view this content.

in which I can have an indeterminate quantity of Budgets, labs and persons, is it possible to work with DOCVARIABLES? As far as I can see, I must create one DOCVARIABLE for each of these indeterminate elements...

Thanks in advance for your assistance.