Run macro with changes in Excel from BO XI R2?

sdk development
1

Hello, I run an macro from DesKi to save an report as XLS file en open it. Now I have to put new SUM-formulas in the Excel-sheet.
Is it possible to do it in the VBA-code run from DesKI? Or must the User start Excel and start there a new macro. I like to put the VBA-code in 1 place and 1 start.

What is the best solution??? Can sombody help me on the right way? :crazy_face:
Thanks, Els

WITTKAMP (BOB member since 2006-11-01)

2

Hi,

Within your VBA code in DeskI, you will need to use Excel SDK. So you need to reference appropriate Excel libraries, then using those open the created XLS file and add into it what you need. All can be done silently without seeing anything.

You could find some examples of codes perhaps also in this very same forum. If not then you would need to google.

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

3

Is Excel SDK difficult working with? I had just a course VBA Excel.
Can I use VBA-code in Excel SDK?

Thanks,
Els

WITTKAMP (BOB member since 2006-11-01)

4

Excel SDK and VBA Excel - the same thing :slight_smile:

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