topic Re: Paste method of Worksheet class failed in QlikView

Paste method of Worksheet class failed

pgalvezt — Tue, 31 Jan 2012 02:18:59 GMT

Hello, When I try to export my chart into the file excel. The macro paste my last selection. I don´t know why happen this.

Thanks!

Paste method of Worksheet class failed

pgalvezt — Tue, 31 Jan 2012 16:19:57 GMT

Hello!

Anyone can help me with this pls?

Thanks!

Paste method of Worksheet class failed

pgalvezt — Tue, 31 Jan 2012 19:34:19 GMT

Any Ideas?

Re: Paste method of Worksheet class failed

Miguel_Angel_Baeyens — Tue, 31 Jan 2012 22:48:24 GMT

Hi,

The you need to activate the object before copying it to the clipboard. Using your code and cleaning it up a bit

Sub print_excel()

     Dim kost
     Set XLApp = CreateObject("Excel.Application")
     XLApp.Visible = true
     Set XLDoc = XLApp.Workbooks.Add
     kost = "Sheet1"
                       
     Set obj = ActiveDocument.GetSheetObject("CH12")       'To Copy  text object as image
     obj.Activate '' you need this line to make this the most recent object selected
     obj.CopyBitmapToClipboard
     XLDoc.Sheets(kost).Range("H2").Select
     XLDoc.Sheets(kost).Columns("G").ColumnWidth = 9
     XLDoc.Sheets(kost).Paste
         
End Sub

Hope that helps.

Miguel

Paste method of Worksheet class failed

pgalvezt — Wed, 01 Feb 2012 01:33:48 GMT

Hello Miguel, its rare but the macro paste the last selection that I have had. For Example I pasted your code put into the macro module, execute and appear an Excel with your code and not the chart.

The macro paste this:

Sub print_excel() Dim kost Set XLApp = CreateObject("Excel.Application") XLApp.Visible = true Set XLDoc = XLApp.Workbooks.Add kost = "Sheet1" Set obj = ActiveDocument.GetSheetObject("CH12") 'To Copy text object as image obj.Activate '' you need this line to make this the most recent object selected obj.CopyBitmapToClipboard XLDoc.Sheets(kost).Range("H2").Select XLDoc.Sheets(kost).Columns("G").ColumnWidth = 9 XLDoc.Sheets(kost).Paste End Sub

Paste method of Worksheet class failed

pgalvezt — Wed, 01 Feb 2012 13:55:06 GMT

Why happens that? I've tried all ways to export but its not working.

Re: Paste method of Worksheet class failed

Miguel_Angel_Baeyens — Wed, 01 Feb 2012 17:25:57 GMT

Hi,

I missed some part yesterday, the code above was working in some cases because it was pasting the chart from previous attemps. Certainly, you (the button that triggers the macro) need to be in the same sheet where the object is to copy it to the clipboard, I don't know if that's the expected behavior or not.

It doesn't work even when you activate the sheet where the object is, if the button is placed in another sheet. As far as I have tested, it exports fine, but it does not copy the image to the clipboard.

But it came to my mind some code provided by Stefan Walther from QlikTech in his blog you can use for that. Check here on how to use it. I'll keep checking that behavior

Hope that helps.

Miguel

Re: Paste method of Worksheet class failed

pgalvezt — Thu, 02 Feb 2012 00:30:22 GMT

Hi, nice post. Now I need to know if QlikView export from differents sheets to xls files. Until now in my application for each sheet in QlikView I have to put each bottom that export the charts. But what I want is to create a menu where exist just one bottom and export all the entire sheets into the xls files.