Multiple excel exports

[mfl]

I need to create an excel BOM for our overseas plant.

I created a script that performs 4 other scripts that gen an excel file depending on a layout.

17 : Import & Export Scripts: 17-0001 BOM Excel Export Main 

Allow User Abort [ On ] 

Set Error Capture [ On ] 

Freeze Window 

Move/Resize Window [ Current Window; Height: 5; Width: 5; Top: 5; Left: 5 ] 

#1 Export Fabrics 

Perform Script [ “17-0050 BOM Excel Export Fabrics”; Parameter: " " ] 

#2 Export Trims & Notions 

Perform Script [ “17-0055 BOM Excel Export Trims & Notions”; Parameter: " " ] 

#3 Export Car & Content 

Perform Script [ “17-0060 BOM Excel Export Care & Content”; Parameter: " " ] 

#4 Export Logo 

Perform Script [ “17-0065 BOM Excel Export Logo”; Parameter: " " ] 

Close Window [ Current Window ]

The individual scripts are pretty much the same as this one.....

17 : Import & Export Scripts: 17-0050 BOM Excel Export Fabrics 

Allow User Abort [ On ] 

Set Error Capture [ On ] 

Freeze Window 

Go to Related Record [ From table: “Style_Chart_Fabrics”; Using layout: “2370 Print 2: Fabrics” (Style_Chart_Fabrics) ] 

[ Show only related records; New window ] 

Save Records as Excel [ Records being browsed; Use field names as column names ][ Restore; No dialog ] 

Is it possible to create one excel spreadsheet that contains 4 tabs of info instead of 4 different spreadsheets.

I didn't see an option like when saving PDFs where you can append to previous.

Thanks

Michael

Edited April 7, 2010 by Guest