B
Bunert
I have an Access 2000 report that I want to export to Excel 2000.
The Access 2000 report is pre-existing and has 50 columns. Running the
report to the screen and looking at the form open event shows that the
report labels are set ate run time. For example, there is a column titled
CURRENT that when the report is run, the label is chaged to the result of
the Date() function.
When I export the report to Excel, I do not get the labels, just the fields
and its doesn't allow me to set the name property.
Is there anyway I can export a report to excel and adjust columns titles at
run-time?
Also, is there anyway to export an Excel formula? There are some columns
that total values in the row. Today, they export to a spreadsheet and copy
and paste an excel formula so that it auto updates as they change data. Is
there anyway I can fill the report field in Access with the Excel formula so
that its automatically there for them?
Thanks
The Access 2000 report is pre-existing and has 50 columns. Running the
report to the screen and looking at the form open event shows that the
report labels are set ate run time. For example, there is a column titled
CURRENT that when the report is run, the label is chaged to the result of
the Date() function.
When I export the report to Excel, I do not get the labels, just the fields
and its doesn't allow me to set the name property.
Is there anyway I can export a report to excel and adjust columns titles at
run-time?
Also, is there anyway to export an Excel formula? There are some columns
that total values in the row. Today, they export to a spreadsheet and copy
and paste an excel formula so that it auto updates as they change data. Is
there anyway I can fill the report field in Access with the Excel formula so
that its automatically there for them?
Thanks