How to export a Pre-define format of Excel File

[d1132]

I have been working for a project in container terminals for data collection and reporting.

Since different shipping company required different format of data in Excel format, how can I do it?

My first guess is using filemaker to trigger a script of VBS and output the data in the excel while this stupid data will be translated into some defined format via some macro function.

DO you all have the solution or some sample post here? I have tried all the method for half a year.

Thank you

Fenton