SAP Business Objects Financial Consolidation Excel Add-In Automation

lglynn

New Member
Joined
Feb 11, 2015
Messages
1
I have a SAP Business Objects Web 7.5 Add-in in Excel 2007.

The add in itself is made up of a compiled .xll file (CtExcelLinksWeb.xll) and a number of dll's.

A bit of vba shows the xll is registered, and all of its registered functions.

However, when I try to use one of these functions in VBA using Application.Run(), I get

Runtime 1004 - Macro may not be available or may be disabled.

I have tried registering the xll within the same sub (Application.RegisterXLL ()) and upon registering a VBAProject called CtEmpty.csv is created

I want to be able to automate the use of this add-in using VBA as it does long winded repetitive tasks, and then I can work on figuring out how to use the functions

Any help will be appreciated
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Tidus211

New Member
Joined
Feb 28, 2018
Messages
1
Hi !
How did you manage to see the functions of this xll? Have you been able to make it work, if yes how ?

Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,118,121
Messages
5,570,306
Members
412,318
Latest member
angoeyuan
Top