Copy to ClipBoard - Excel Format

pkelly — Thu, 07 Oct 2010 13:33:49 GMT

Hi all...

To get past an issue with MS Excel number formats, I am exporting to MS using the following macro...

Set chart = ActiveDocument.GetSheetObject("CH600")

' Copy Chart to Clipboard

chart.CopyTableToClipboard true

' Open Microsoft Excel and Add Worksheet

Set XLApp = CreateObject("Excel.Application")

XLApp.Visible = True

Set XLDoc = XLApp.Workbooks.Add

Set XLSheet = XLDoc.Worksheets(1)

XLSheet.Paste XLSheet.Range("A1")

Set Selection = XLSheet.Cells

With Selection

.Borders.ColorIndex = 0

End With

XlSheet.Range("A1").Select

This almost works for me.

The issue I have is that , my GM% column displays in QlikView as a % to 1 dp but in Excel it outputs as % to 2 dp with the second dp = 0.

Anyone came accross this / have any suggestion on fixing?

Regards

Paul

pkelly — Thu, 07 Oct 2010 20:54:46 GMT

Any help on this?

pkelly — Thu, 14 Oct 2010 14:49:18 GMT

Anyone....?

topic Copy to ClipBoard - Excel Format in QlikView