Savings to Excel with Field Title Modified?

[_henry_]

Hello all,

I have been asking this question in the past and I just want to know if there will be any ideas on this? Thanks..

I am doing parsing from reports (generic reports parsing). I want to know if FileMaker can modify the Field Title when savings to Excel.

For example: I have 3 Fields which are Account Number, Names, and Balance. I would like FM to export to Excel like this:

Account Number Names Balance Date

12345 John Doe 123.55 02/02/08

55555 John Smith 15665.66 01/01/08

But the unique thing is I should set up the "Field Title" in other fields because the field name can change. For the next report, the field could be like this:

Account Number Names Date Misc.

12345 John Doe 02/03/07 Paid

55555 John Smith 05/05/07 UnPaid

Is that possible for FM to do that? Or is there workaround? I tried to modify field to TEXT field, however, when I exported to Excel, it would ask to convert to a number field.

If you need more information, I can give more explanation.

Thank you.