M
marc vda via AccessMonster.com
Hi,
I'm using an Access2000 db to collect all kinds of data and to report on it.
For the reporting part, I created excel-sheets that are completely
preformatted. Through AccessVBA I open the excel-sheet (kind of template, but
..xls-format), and using rs.copyfromrecordset I push the data to hidden excel
tabs, and saveAs the workbook afterwards.
In the excel-sheet are other (visible) tabs that look up values in the data-
tabs. Some cells on these visible tabs that were formatted as percentage in
the template, suddenly have become a dateformat in the result.
Anyone knows why this happens, and how to avoid it ?
thx,
Marc.
I'm using an Access2000 db to collect all kinds of data and to report on it.
For the reporting part, I created excel-sheets that are completely
preformatted. Through AccessVBA I open the excel-sheet (kind of template, but
..xls-format), and using rs.copyfromrecordset I push the data to hidden excel
tabs, and saveAs the workbook afterwards.
In the excel-sheet are other (visible) tabs that look up values in the data-
tabs. Some cells on these visible tabs that were formatted as percentage in
the template, suddenly have become a dateformat in the result.
Anyone knows why this happens, and how to avoid it ?
thx,
Marc.