Problems During Paste/Formatting of Tables From Excel to Word

J

Joan

I am using VBA based in an Excel spreadsheet to generate a large number (> 100) of large tables (some > 200 rows), which are then copied/pasted to a Word document. After pasting, they are formatted for appearance

During the pasting/formatting process, I have run into several problems. I add a line of text (font style HeadingX) above each table, and sometimes the text comes out Normal. Sometimes the tables are not formatted. Sometimes I receive an error in Excel (where the program is based) stating that it is waiting for an OLE operation to end in another application. I shut down the Word application (save & quit) every 10-15 tables, but that doesn't seem to help

Any suggestions
 
W

Word Heretic

G'day "Joan" <[email protected]>,

I am sorry that I don't have the time to test some solutions for you.
Here is what I would be testing though:

export as CSV, import into Word (no styling available)

Converting tables to tabulated lists until the very end.

Various PasteSpecials


Also your styles may need to be set in the template for the new Word
Document.

Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)


Joan reckoned:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste to excel from word - auto format problem 1
Problem with MS Word paragraph and character styles: format getting messed up 2
Excel does not accept text format! 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Pasting a cell into bookmarked table from excel vba 1
Linking data in MS Word into Excel 5
VBA - (re-) Set a Table Style 2

Top