Excel sheet name

[ChiragB]

Here is an intersting observation. When you save any impromptu report into an 'excel with format' type file it saves the data on "Sheet1". Now, without exiting impromptu if you try to save the same report in the same excel file (with the formatting) it saves it on "Sheet3" ("Sheet1" and "Sheet2&quot don't exist and so on. I am writng an Excel macro that reads the values from this "Sheet1" of this file and it wouldn't work if "Sheet1" is absent. Is there anyway to export the values with formatting (Excel with format) into "Sheet1" of the excel file always? The only way I can do it is by quiting Impromptu and running it again.

 

[drlex]

ChiragB,
I don't know if there's a way to specify the sheet in Impromptu, but you could use OLE calls to Excel to rename the sheet from sheet3 to sheet1.
HTH
lex