SAP Business Objects Financial Consolidation Excel Add-In Automation
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
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By NU2vba in forum Excel Programming / VBA / Macros
Last Post: 07-17-2014, 03:59 PM
By nicko54 in forum Excel General
Last Post: 01-05-2011, 12:25 PM
By corinereyes in forum Excel General
Last Post: 11-18-2007, 01:18 PM
By johnnywyoming in forum Excel General
Last Post: 11-14-2005, 07:15 PM
By lrs52200 in forum Excel - New Users/Basics
Last Post: 09-18-2005, 12:05 AM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1