Macro - Copy Text To Clipboard Header Problem - Qlikview
I have an Excel file that contains formulas. I export some objects (Pivot Table) from qlikview to excel by using macro and I have to use CopyTextToClipboard for merged cells and cells with formula to use SUMIFS in excel file. Everything works fine but when the macro is complete, the export table does not contain the headers.
PS: Using CopyTableToClipboard True/False is useless for this problem
Path = "Myfilepath\" FileName = "Myfilename" strSaveFile = Path & FileName '============================================================== set oXL=CreateObject("Excel.Application") Set oXLDoc = oXL.Workbooks.Open("Myfilepath.xlsx") oXL.visible=True