Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Sonia,
Could you plz share your application.
Thanks,
AS
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
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.
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.?
Hi Sonia
Could you upload a sample app. This makes it easier.