Solved

Scheduling and Retrieving Business Objects Reports through MS Access VBA

Posted on 2008-10-15
3
1,017 Views
Last Modified: 2013-11-27
We distribute several hundred reports at the 1st and middle of the month.  We have an Access database where we track the reports - who they go to, where they are stored, etc.  In order to have a central location, we also have the Business Objects  reports documented here and with the prior version of BO, we were able to submit them to the BCA and then retrieve them and store them as the proper file type (which was documented in our Access database).   With the XI release the DocAgentOption is no longer available.  Can anyone help me with how (or even if) I can schedule reports and retrieve them with XI.  Thanks!
0
Comment
Question by:Jeanice
  • 2
3 Comments
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 500 total points
ID: 22747253
0
 

Author Comment

by:Jeanice
ID: 22797931
I'm working on it as I have time.  It's taking me awhile to figure out what references I need.
0
 

Author Closing Comment

by:Jeanice
ID: 31506528
I had this document and your post helped confirm I was on the right track.  
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now