Excel

[raj23kr]

When I use Excel Class it does all the work in background however I want it to be displayed in foreground. Also How can I save/discard changes silently and to set options in case of overwrite.

[Gintaras]

Set Visible property of Application object to TRUE.

Don't remember. Workbook or Application or Worksheet object has Save or/and SaveAs methods.

Several examples are here in forum. Also look in Forum -> Resources -> first topic.

[raj23kr]

Thanks I found. One more thing how can I clear clipboard of Excel as when I close excel it ask for wheter to leave data in clipboard. I want to escape this dialog box.

[Gintaras]

str c.setclip