Excecting excel macro

[Former Member]

Hi,

I have an excel macro, in which the user insert some inputs , press buttons

and as a result, new file is being generated with list of suppliers.

I would like to activate this excel application from web dynpro.

Can someone tell me if it's possible to call excel macro from web dynpro

and how.

Thanks,

Ronit.

[Former Member]

I'm still Stefano..

sorry I forgot to say that I'm working in the BW-SEM platform

thanks yet..

[Former Member]

Hi to everybody,

I've another kind of problem; I would like to know if it is possible to mantain some excel functionality, even using macros.

Like:

- color cells

- move colums

- sum some values in a colum

- other..

Really thanks in advance!!!!!!!

Stefano, Italy

[Former Member]

Hi,

you can't call the macro directly...I think, but you can open the excel file that contains the macro. Just write a macro that starts itself automatically when the excel file is open.

Bye,

Vito

[Former Member]

Hi,

I will try...

Thanks,

Ronit.

[former_member182374]

Hi Ronit,

Open you excel file, go to VB editor (ALT F11).

Add the following code to "ThisWorkbook"

Private Sub Workbook_Open()
your code
End Sub

p.s

You must set the security low (Tools -> Macro -> Security -> Security Level)

Omri

[Former Member]

Hi Omri,

So the steps to be taken are:

1. Execute inside Workbook_Open <b>all needed macros</b>, or one that executing all the others

2. Open the excel file by Web Dynpro, which activate the Workbook_Open

Did i miss something?

Thanks a lot,

Ronit

[former_member182374]

Hi Ronit,

Yes, try it.

Omri