>>I am converting xslx to xls
>>
>>This is my code
>>
>>oXL = CreateObject("Excel.Application")
>>oXL.Workbooks.Open("c:\citisprint\attachxls\latest.xlsx")
>>oXL.ActiveWorkbook.Saveas("c:\citisprint\attachxls\latest.xls", 39)
>>
>>Conversion works fine except that the date in the xslsx file of 24/10/16 gets converted to 42667 in the xls file
>>
>>Any ideas
>>
>>Colin
>
>In Excel, {^2016-10-24} is just the representation, as a date, of the number 42667. Dates
are numbers, as offsets from {^1899-12-30}. That is, if you add {^1899-12-30} to the number in the cell, you'll get the date displayed when the cell is formatted as a date.
Sorry I dont understand how to do that
oXL = CreateObject("Excel.Application")
oXL.Workbooks.Open("c:\citisprint\attachxls\latest.xlsx")
oXL.ActiveWorkbook.Saveas("c:\citisprint\attachxls\latest.xls", 39)
How do I do that to column h in the active workbook lates.xls - what is the code I need to use
Thanks
Colin
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing