export Report toexcel (name of field)

  • Thread starter Thread starter Mirco
  • Start date Start date
M

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
 
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.
 
THANK OU VERY MUCH, I'LL TRY


U¿ytkownik "Ken Snell said:
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>

Mirco said:
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
Click to expand...
Click to expand...
 
Back
Top