Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting to Word
You could find the address of the bottom right cell of the chart, then
copy and paste a picture of the range. For example: Dim strCell As String strCell = ActiveSheet.ChartObjects("Chart 138").BottomRightCell.Address .. .. With ActiveSheet Range(Range("A9"), Range(strCell)).CopyPicture _ Appearance:=xlScreen, Format:=xlBitmap Michael wrote: Hi Guys, I have a macro that copies a range in excel and exports it to word. My problem is won't copy the linked chart when I select the used range. How do I write a routine that will copy both the range and chart and insert them both into word. Also I have found that it will also not paste special as a bitmap, only as an excel worksheet. I attach code below which I have edited from a previously answer post in this newsgroup Thanks for your help Michael Private Sub CommandButton2_Click() Worksheets("calculations").Select Application.CutCopyMode = xlCopy Application.DisplayAlerts = False On Error Resume Next Dim rng As Range With ActiveSheet Range(Range("A9"), ActiveCell.SpecialCells (xlLastCell)).Copy .ChartObjects("Chart 138").Activate .ChartArea.Select .ChartArea.Copy Dim APPWD As Object Dim i As Integer Set APPWD = CreateObject("Word.Application") APPWD.Visible = True APPWD.ChangeFileOpenDirectory ActiveWorkbook.path APPWD.Documents.Open Filename:="NewCashflow.doc", ConfirmConversions:=False, ReadOnly:=True APPWD.Selection.PasteSpecial Link:=False, DataType:=wdPasteBitmap, _ Placement:=wdFloatOverText, DisplayAsIcon:=False Application.DisplayAlerts = True End With End Sub -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting graphs to Word | Excel Discussion (Misc queries) | |||
Exporting information to a word doc | Excel Discussion (Misc queries) | |||
Exporting to Word in a csv file | Excel Discussion (Misc queries) | |||
exporting excel worksheet to word | Links and Linking in Excel | |||
exporting single cells to Word | Excel Discussion (Misc queries) |