I currently run multiple query statements simultaneously using F5. This generates several Grid # Tabs in the Editor; one Grid # Tab for each of the query statements.
I would like to have the capability to save all the Grid # Tabs in one Excel file under one Sheet # (and also have the option to save each Grid # in its own Sheet #) and all these in one procedure process (non-repetitive process)?
Perform a Save As on each of the Grids #"s as Excel Instance (leave the Excel Instance open) and the Grid #'s will be appended in the open Excel Instance. Each Grid # is placed in its own Sheet #. After performing a Save As on all the Grid #"s, perform a Save on the open Excel Instance.
Enhancement Request ST65265 has been submitted to Development for consideration in a future release of Toad for Oracle.