Macro Issue with Windows 7 client

Mon, 26 Jan 2026 18:19:17 GMT

As Qlikview exports data into .xls it allows only 256 characters per cell. Here we have data of more than 256 characters per cell. So that I created macro to copy from QV table and paste into .xlsx. It works fine with XP client and not works with Windows 7 client.

Server O/S: Windows 2008 R2

Client O/S : Windows XP SP3 - This macro is working fine

Client O/S : Windows 7 - This macro throws error saying "PasteSpecial method of worksheet class failed"

Macro Script:

'----------------------------------------------------------------------------------------

Public Sub ExportUnTruncated
set v=ActiveDocument.Fields("Report_Name")
If(v.GetSelectedValues.count >=1) then

set XLApp = CreateObject("Excel.Application")
XLApp.Visible = False
set XLDoc = XLApp.Workbooks.Add
set table = ActiveDocument.GetSheetObject("CH17")'Copy table and paste into Excel
set XLSheet = XLDoc.Worksheets(1) 'get the reference to the first sheet
XLSheet.Activate

table.CopyTableToClipboard true
XLSheet.Range("A1").PasteSpecial

XLSheet.Range("A1").Cells.CurrentRegion.Borders.ColorIndex = 0
XLSheet.Cells.WrapText = False
XLApp.Visible = True
Else
Msgbox("Please select Week to Export this Report")
End If

end sub

'----------------------------------------------------------------------------------------

Can you guys help me to solve this issue. Thanks in advance

Regards,

Yoga

Re: Macro Issue with Windows 7 client

Wed, 04 Jul 2012 07:33:24 GMT

I have tested the above macro with another Windows 7 client, It is working fine.

Issue now is it works fine with some windows 7 client and not works with another Windows 7 client and it throws "PasteSpecial method of worksheet class failed".

I assume that, may be missing some permission of IE.

topic Re: Macro Issue with Windows 7 client in QlikView

Macro Issue with Windows 7 client

Re: Macro Issue with Windows 7 client