Exporting charts as pic and tables as excel files

[Anonymous]

Helol,

I have a report that contains charts and tables.

I already have a script that is exporting the charts and tables as pictures into ppt. I'm using this one that I found here.

Sub export
'An array with the objects you want to export to powerpoint
Dim myArray(3)
myArray(0) = "CH01"
myArray(1) = "CH02"
myArray(2) = "CH03"
myArray(3) = "CH04"

'Create ppt object
Set objPPT = CREATEOBJECT("Powerpoint.Application")
objPPT.Visible = True
Set objPresentation = objPPT.Presentations.Add

  'For each object in the array create a new slide and paste it.
For each item in myArray

Set PPSlide = objPresentation.Slides.Add(1,11)
ActiveDocument.GetSheetObject(item).CopyBitmapToClipboard
PPSlide.Shapes.Paste

Next
'Clean up
Set PPSlide = Nothing
Set PPPres = Nothing
Set PPApp = Nothing

msgbox "PPT Extract Successful",64,"Complete"

End Sub

However, CH02 and CH04 are actually tables and I'd rather have them exported as Excel and added, as object, into my ppt.

Currently I manually export them from Qlik into Excel, save them on my machine and insert them as object into the ppt.

Is it somehow possible to do this via a macro as well?

Any help welcome.:D

[Anonymous]

Hello Petter,

well.. that would still require me to save the charts as Excel files first.

I'm not feeding QlikView with Excel Files but with a db connection.

So the idea was to extract that tables from Qlik into Excel and save those as linked objects in ppt.

BR

Susanne

[petter]

I am not sure if I understand what you say now ... I am just using Excel as an intermediary - not saving any Excel-files as such. The Excel-file is actually embedded into the PowerPoint - that is why you can double-click the table and still edit it as a full Excel-file ... but it is not stored on the file-system but only in the PowerPoint.

The VBA-code could be put into a controlling Excel-file but it could also be put into a PowerPoint.