Hello
I have an excel/Access automation questions. I have produced a recordset from listbox selections which i move to a temporary table then i have an excel template which i export the data to starting at row17. The field names in the access table and the column headings in the excel sheet have to be exactly the same and in the same order for this to work otherwise the field values end up in the wrong column.
This works fine except one of the columns has a calculated field and after the export this calculated fields formula is deleted for everyrow of the export. So if there are 3 records exported the formula is deleted in rows 1 to 3 but is still present in row 4. Is there anyway to stop this happening
Another question relates to a similar theme. I need to import the completed template back and then export to another spreadsheet and find the next unpopulated row so this will be different everytime. How do i export to a spreadsheet access date and export to the next available row?
Anyhelp on this greatly appreciated. I will post this in the Access section also
Thanks
I have an excel/Access automation questions. I have produced a recordset from listbox selections which i move to a temporary table then i have an excel template which i export the data to starting at row17. The field names in the access table and the column headings in the excel sheet have to be exactly the same and in the same order for this to work otherwise the field values end up in the wrong column.
This works fine except one of the columns has a calculated field and after the export this calculated fields formula is deleted for everyrow of the export. So if there are 3 records exported the formula is deleted in rows 1 to 3 but is still present in row 4. Is there anyway to stop this happening
Another question relates to a similar theme. I need to import the completed template back and then export to another spreadsheet and find the next unpopulated row so this will be different everytime. How do i export to a spreadsheet access date and export to the next available row?
Anyhelp on this greatly appreciated. I will post this in the Access section also
Thanks
