Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Embedding Excel graphs in Word
I'm building an Office Application with Excel part of the application. This
is all being done using Office 2000 Professional running under XP Pro (SP2) I have embedded several Excel tables and associated graphs in a Word document. I have done this using VBA, sucking in the tables and graphs from Excel, to bookmarked locations in Word. All works fine except that I have these surplus table rows appended after each graph in Word, causing unnecessary page breaks in Word, which then have 2B manually deleted. I have assigned each table and graph combination a range named in Excel. The range extends over the table and the graph completely. 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Embedding Excel graphs in Word
Try to embed them as pictures. That way you can exactly control the material
being copied/pasted. In Excel, while holding down the SHIFT key, pull-down: Edit Copy picture.. In Word (or PowerPoint) just paste -- Gary's Student "Richard John" wrote: I'm building an Office Application with Excel part of the application. This is all being done using Office 2000 Professional running under XP Pro (SP2) I have embedded several Excel tables and associated graphs in a Word document. I have done this using VBA, sucking in the tables and graphs from Excel, to bookmarked locations in Word. All works fine except that I have these surplus table rows appended after each graph in Word, causing unnecessary page breaks in Word, which then have 2B manually deleted. I have assigned each table and graph combination a range named in Excel. The range extends over the table and the graph completely. 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Embedding Excel graphs in Word
To elaborate, move the chart using copypicture/paste, and move the table by
copying an appropriately sized range and pasting, probably as html, although I forget how Office 2000 used to do it (yes, there have been changes across the versions). I have some code you can try he http://peltiertech.com/Excel/XL_PPT.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Gary''s Student" wrote in message ... Try to embed them as pictures. That way you can exactly control the material being copied/pasted. In Excel, while holding down the SHIFT key, pull-down: Edit Copy picture.. In Word (or PowerPoint) just paste -- Gary's Student "Richard John" wrote: I'm building an Office Application with Excel part of the application. This is all being done using Office 2000 Professional running under XP Pro (SP2) I have embedded several Excel tables and associated graphs in a Word document. I have done this using VBA, sucking in the tables and graphs from Excel, to bookmarked locations in Word. All works fine except that I have these surplus table rows appended after each graph in Word, causing unnecessary page breaks in Word, which then have 2B manually deleted. I have assigned each table and graph combination a range named in Excel. The range extends over the table and the graph completely. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Embedding Excel Data into Word | Excel Discussion (Misc queries) | |||
Embedding a Word Doc in Excel 2007 | Excel Discussion (Misc queries) | |||
embedding a Word Document into Excel | Excel Worksheet Functions | |||
Excel 7 to powerpoint 7 - embedding graphs but not linking | Excel Discussion (Misc queries) | |||
Embedding Word Document within Excel | Excel Programming |