Buddy: Wouldn't the second gateway export simply overwrite the same filename that the first one created? I didn't think that a gateway export would append data to a file that's already out there. Could be wrong, I've never tried it. That would present a problem to me because in my code I usually don't delete the file first, and would expect every gateway export to overwrite a file that's already out there.
Karen > > DELETE C:\TEMP\MyWorkSheet.XLS > > GATEWAY EXPORT XLSW C:\TEMP\MyWorkSheet.XLS + > SELECT blah blah….. OPTION BLANK_IF_ZERO ON + > |SHEET_INDEX 0 + > |TAB_NAME something + > |COL_NAMES ON ….. > > GATEWAY EXPORT XLSW C:\TEMP\MyWorkSheet.XLS + > SELECT Blah Blah …. OPTION BLANK_IF_ZERO ON + > |SHEET_INDEX 1 + > |TAB_NAME somethingElse + > |COL_NAMES ON ….. > > Notice the Sheet_INDEX option this is your key always start with 0 and > continue from there. > > > > Buddy > > >
