Extract data into Excel and enable macros from PL/SQL procedure

Hi,

I have an Oracle PL/SQL procedure that extracts data into an excel worksheet. I am wondering if there is anyway from the procedure to also set the macros of the excel document that is created?

For example, usually the macros are manually done:
Go to Tools, Macros – Macro. Select the “Automate” macro and click “run”.

However I am trying to automate the manual process. Any suggestions or direction?

Thanks,
DR

re: Extract data into Excel and enable macros from PL/SQL procedure

hI
Can you please send me that pl/sql procedure that extracts data into an excel worksheet.
As i am working on a similar case
Email id: [ Removed ]
Thanks alot
Nitin Singh

re: Extract data into Excel and enable macros from PL/SQL procedure

Setting a macro would not be possible from PLSQL.
Could you please tell what is that macro going to do?

One suggestion would be to connect to oracle database from Excel using macro and fetch the data in to excel sheet.

re: Extract data into Excel and enable macros from PL/SQL procedure

You can't set macros form PL / SQL.

re: Extract data into Excel and enable macros from PL/SQL procedure

Hi, I have the same request. I am collecting data via PL/SQL procedure and downloading them in excel. I have a macro that runs a chart. I am trying to make the whole report automated. Any other workaround for the macro to run?
Thanks.

re: Extract data into Excel and enable macros from PL/SQL procedure

I hope you would have got the answer from the above posts that setting a macro using PLSQL is not possible.
You can rather connect to oracle DB from excel using macro and fetch the data and store them in the oracle work book.

re: Extract data into Excel and enable macros from PL/SQL procedure

hi...
i would like to know about the procedure that u used to extract data into excel.

re: Extract data into Excel and enable macros from PL/SQL procedure

Can some please put up the Stored proc to load data from a table into excel file?

re: Extract data into Excel and enable macros from PL/SQL procedure

you can "run" a macro using client-side client_ole2 code , use:

args:=client_ole2.CREATE_ARGLIST;
client_ole2.ADD_ARG( args, V_MACRO_NAME );
client_ole2.INVOKE( Application, 'RUN' ,ARGS );
client_ole2.destroy_arglist(args);

re: Extract data into Excel and enable macros from PL/SQL procedure

Hey,

We are really happy with this tool called Excellant. It allows you in pl/sql to create clobs of excel using xml and sql. It does styles, formulas and multi sheet. Not sure about macros. The website is http://www.peak42solutions.com. We started using them a few weeks ago it rocks.

Bill