We have LotusScript code that outputs data from Lotus Notes databases to an Excel spreadsheet. We use the CreateObject(“excel.application”) method. Nothing fancy.
Where is the temporary Excel file created? We can’t seem to locate where this file resides immediately after the output has been generated.
The File-Save always points to the “My Documents” folder instead of the folder where the temp file was created.
Any help greatly appreciated!