LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Exporting Excel Graphs

I'm building an Office Application including Excel using Office 2000
Professional running under XP Pro (SP2)

I have embedded several Excel tables and associated graphs in a Word
document using VBA. The problem is that a number of surplus table rows are
appended after each graph in Word, causing unnecessary page breaks in Word,
which then have 2B manually deleted.

Each table and graph is assigned a range name in Excel. The range definition
covers the table and the graph completely which I think is causing the
problem. Does anyone know of a "clean" way to pluck out Excel tables and
graphs for embedding into Word without all those surplus table rows? eg. Is
it possible to just plug the graph into Word from Excel using VBA?


--

Richard John



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting graphs to Word kippers Excel Discussion (Misc queries) 3 April 9th 09 01:34 PM
exporting multiple graphs from excel to powerpoint JPhish Excel Discussion (Misc queries) 1 March 17th 09 04:39 PM
Are there better GRAPHS within EXCEL or Add-on graphs? Deb Charts and Charting in Excel 1 February 1st 06 01:19 PM
Automatic Graphs/ Dynamic Graphs DanielWalters6 Charts and Charting in Excel 1 January 24th 06 09:29 PM
Exporting EXCEL Graphs as .gif (image file) using VBA or VB haresh7263 Excel Programming 1 July 11th 05 02:39 AM


All times are GMT +1. The time now is 11:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"