Reply
 
Thread Tools Display Modes
  #1   Report Post  
Jeff Rush via OfficeKB.com
 
Posts: n/a
Default Macro to Convert All Embedded Excel Tables to Text

Hello all.

Hopefully someone might have some insight into my situation.

We process a lot of Word documents which contain embedded excel tables.

The current process involves opening the document, opening the embedded
table to edit, copying all information, pasting into the document as text,
deleting the old embedded table, then going on with our custom conversion
process.

I am trying to create a macro which we could run on each word document to
convert all of the embedded excel tables into a plain text format.

I figure there has to be a way, but it has been so long since I have worked
with VBA I am quite rusty.

Any advice would be greatly appreciated.

I am needing to implement this as soon as possible.

Thanks!

--
Message posted via http://www.officekb.com
  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi Jeff,

There is no way, basically, other than the one you're already using: opening
the Excel object and extracting the data, either by copy/paste, or by writing
the cell information, cell-by-cell, into a Word table.

I assume this is that point at which you're "stuck"? In which application is
most of your VBA experience?

We process a lot of Word documents which contain embedded excel tables.

The current process involves opening the document, opening the embedded
table to edit, copying all information, pasting into the document as text,
deleting the old embedded table, then going on with our custom conversion
process.

I am trying to create a macro which we could run on each word document to
convert all of the embedded excel tables into a plain text format.

I figure there has to be a way, but it has been so long since I have worked
with VBA I am quite rusty.


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

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use text wrap property for tables. Nandini Tables 7 March 22nd 05 05:18 PM
Text running together in embedded tables SAM Tables 1 March 22nd 05 12:48 AM
Excel text displays incorrectly Zach Microsoft Word Help 4 January 17th 05 02:23 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM
Outline Renee Hendershott Page Layout 2 December 25th 04 02:49 PM


All times are GMT +1. The time now is 09:53 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"