Save to Excel template and/or then run VBA in Excel

building reports webintelligence
1

I’ve searched and searched but can’t find an answer to this:

I want to save a Webi report to Excel, either to an existing Excel file that has some existing formatting, or extra data manipulations, or save to an Excel file that then runs some existing VBA code.

Examples are:

Save a table of data to Excel, then add an auto-filter to the top row.

Save a table of data, and create a pivot table or chart on a separate tab.

Save a table of data, then set Excel print setup so that it will fit to page.

I know these are all simple things to do in Excel, but I want to save the end user the task of doing them, so want to automate as part of the save process.

steerpike (BOB member since 2005-07-07)

2

Hi guys - no responses to this as yet!

Is that because its a bad or stupid question? Or have I not explained very well? Or is it just imposible?

Any comments appreciated - thanks

steerpike (BOB member since 2005-07-07)

3

Hi,

As far as I know, this is not possible in BO out of the box. Infoview knows just to save the report into an XLS format. It’s not capable of further formatting the report in Excel.

What is maybe possible is to use SDK where you would call Excel SDK to manipulate with the report format after it has been saved in XLS. Search in the SDK forum to see whether something like this has been discussed already.

Marek Chladny :slovakia: (BOB member since 2003-11-27)