automatic excel export

[pajen]

Situation:
1.Running a SQL request.
2.Right click in the result -> export to Excel.
3.Choose target/folder for saving file and filename.

Needs:
Code (like a macro) that can be added at the end of the request that takes care of this annoying right click procedure with the following file save.

Regards Peter

 

[herzig]

I would appriciate something like that.

In our apps we have solved it this way:
Data is not opened in new, empty worksheet, but (selectable) "hand-made" template, including save macro and some cell function logic.
save macro looks to specific (named) cell, which again can hold typical excel logic.
Thus final name is retrieved via dynamic sheet contents, it's up to users preferences and content "design".

All PLSD need is call of specific template set by preferences instead of empty one.

 

[pajen]

Thank you. Perhaps a stupid question: where do you set those preferences in PLSD?

regard
Peter

 

[herzig]

Oh, maybe You got me wrong.

I did only suggest this behavior and described it similar to we do it with our own applications.

In short, on top of plain Excel Export PLSD needs this function:
"Export using [this]Excel Template"
Where [This] can be choosen out of PLSD preference set.
After fill in the data, a call to a standard PLSD makro placed in this Excel template would be nice.