export Report toexcel (name of field)

[Mirco]

Hello !
When I export a raport to an Excel file, the name of the field in excel is
taken from the name of the field of the raport. I would like to use there,
instead of a simple name, a formula as the follow :=Month((CDate([Data])+1))
& "/03". The problem is that I can;t use this formula for name the columns
of excel !

I hope my explanation of the problem is enought clear

thanks

mirco

 

[Ken Snell]

TransferSpreadsheet command will not let you specify the names of the header
cells in the EXCEL spreadsheet. If you set the "Headers" argument of this
command to True, it does what you're seeing: viz., it puts the field name in
as the header.

To put in your own header text, you'd need to use Automation to modify the
spreadsheet after it's created. Or use Automation to create the spreadsheet
(the headers and the data) directly.

 

[Mirco]

THANK OU VERY MUCH, I'LL TRY

TransferSpreadsheet command will not let you specify the names of the header
cells in the EXCEL spreadsheet. If you set the "Headers" argument of this
command to True, it does what you're seeing: viz., it puts the field name in
as the header.

To put in your own header text, you'd need to use Automation to modify the
spreadsheet after it's created. Or use Automation to create the spreadsheet
(the headers and the data) directly.


--
Ken Snell
<MS ACCESS MVP>

Hello !
When I export a raport to an Excel file, the name of the field in excel is
taken from the name of the field of the raport. I would like to use there,
instead of a simple name, a formula as the follow :=Month((CDate([Data])+1))
& "/03". The problem is that I can;t use this formula for name the columns
of excel !

I hope my explanation of the problem is enought clear

thanks

mirco