I am currently developing a tool in VB 6.0. I am facing a problem when i generate reports in Excel format.
The issue description:
- When I click the 'Produce report button', the vb code will run a query and fetch the record into record set
- and then it will copy into excel
- when copy paste the record set, all the number columns after any date column is changed into Date format.
Eg: The record set of a TimeSheet table have below fields
Emp_Id | Emp_Name | Date | Totalhrs | Uniq_Num
The values produced in the report is
TG0001 | Divakar | 12-Oct-2010 | 1/3/1900 | 1/1/1900
where as it should display
TG0001 | Divakar | 12-Oct-2010 | 3 | 1
I am using Excel 2007 and not sure where the issue is.
I am sure that when copy paste the record set during run time all the columns (here 'Totalhrs' and 'Uniq_Num') changed into date format after copying the date column (here 'Date')
Can anyone please help me on this?