how to export repetition data to excel

[aggregates]

Hi

I'm very new to the Filmmaker.

I have a version 8.5

I am trying to export data to excel,so I can run a macro.

so I need the data from the repetitions to be copied into separate tabs on excel.

but the multiple data in the repetitions show up in one single tab.

is there anyway I can give them separate the output?

thanks

Edited April 8, 2009 by Guest

[Søren Dyhr]

but the multiple data in the repetitions

How did it arrive in repeating fields in the first place? Use only repeating fields for utility purposes ... they can't really hold user enterable data in a normalised database since they're flunking 1NF.

So it can't really be data but instead results of calculations!

I'm fully aware of not giving any kind of usefull reply, to do so would we need to know context and purpose before just getting in the vicinity of an answer.

What is the macro doing, that can't be done in native filemaker?

-sd

[Vaughan]

I don't think that you can export data from FMP and specify it appearing in separate tabs -- at least not simply.

I'm sure it could be done with an XML/XLST export, but that requires some serious self-assembly of the XLST style sheets.

The easiest method might be to export each tab separately then make them into multiple sheets using Excel itself.

But that comes after you have worked out how to split the repeating fields into something more useful, which is what Søren refers to.

[comment]

If the purpose is to run a macro in Excel, then obviously …

[aggregates]

Thanks for the replies

I put the data in the arriving field by using the link and dropbox.

I need to run a macro to add data on a excel based invoice template sheet. I need to assign each tab from the export to tab on this template.

the data consist of names,numbers and calculations.

I will have list of items with the prices.

and I want this each input to be copied to excel tab separately.

Is there an alternative way instead of using the repetition for a lis of data?

Also I was wondering about writing a script to copy and paste from one opened file to the other file, I couldn't figure out how to organize the commends.

Thanks

Edited April 8, 2009 by Guest