topic Re: Macro - Date format Setting in QlikView

Macro - Date format Setting

Fri, 11 Apr 2014 07:28:21 GMT

The date format inside a tabulation is 'DD-MMM-YYYY' but when I export it via Macro, the output which i get is 'D-MMM-YY'.

Is there a way to resolve this.

Re: Macro - Date format Setting

amit_saini — Fri, 11 Apr 2014 07:31:26 GMT

Hi Sonia,

Could you plz share your application.

Thanks,

Re: Macro - Date format Setting

omyahamburg — Fri, 11 Apr 2014 08:02:35 GMT

Hello Sonia

Have you tried in your macro something like

Set curSheet = objExcelWorkbook.WorkSheets(1)

curSheet.Range("A1").NumberFormatLocal = "dd/mm/yyyy" ?

best regards

Joerg

Re: Macro - Date format Setting

Fri, 11 Apr 2014 08:44:53 GMT

sub test

set XLApp = CreateObject("Excel.Application")
set XLDoc = XLApp.Workbooks.Add
ActiveDocument.GetSheetObject("CH65").CopyTableToClipboard true
XLDoc.Sheets(1).Paste()
XLDoc.Sheets(1).Range("A1").Select
XLApp.Visible = true

end sub

this is the code which exports my tabulation into an excel. but i get a wrong date format when i do this.

Re: Macro - Date format Setting

Fri, 11 Apr 2014 08:46:52 GMT

Hi Jorg,

I have tried it out into my application, but I am not able to get the desired result.

Any more help on this.?

Re: Macro - Date format Setting

omyahamburg — Fri, 11 Apr 2014 10:27:09 GMT

Hi Sonia

Could you upload a sample app. This makes it easier.