the export code that i use to open in excel is :
set obj = ActiveDocument.GetSheetObject("CH02")
obj.ExportEx "C:\ExcelTest.xls", 5
For the "use regionnal setting for send in Excel" i find this macro for it but it is not working with XLSX and with open in excel :
set corp = ActiveDocument.GetSheetObject("CH02")
corp.ExportBiff pathcorp & "TEST.xls"
set XLApp = CreateObject("EXCEL.application")
XLApp.Visible = FALSE
set XLDoc = XLApp.Workbooks.Add
for i=0 to val.Count-1
set MyTable = ActiveDocument.GetSheetObject("CH02")
MyTable.ExportBiff path & val.Item(i).Text &".xls"
Set XLApp = Nothing
Set Table = Nothing
'Msgbox "Exported Sucessfully"
finally i need to format the date
in attchment send you the excel file with data
TESTQLIK.csv 3.6 K
my suggestion is to have a hidden copy of your table with the formats you need and then export it with the standard macro function. This will be easier for you to reduce impact changes. If tomorrow you need new formats it will be easier to do it in QV than changing your macro.
If this is not an option we can start working on your macro.
Please let me know if this helps.
i am not sure to understand your solution, i have already an hidden table and i format it with Qlik parameter (exemple number format integer ...)and it is not working when i import thank to the native XL button.
I think that my problem of numeric and date format is induced by the size of the files (more than 65K lines).
Also i have more than 65 different charts that the reason i was thinking of a macro.