Business Objects 6.5 and Excel 2003

kanoor

New Member
Joined
Aug 19, 2008
Messages
5
Hi,

I have excel workbooks which I constantly update with data from Business Objects. I was looking to create a macro to auto update the excel sheets. Would anyone be kind enough to give me some inputs into this please? It will be better if I let you know first that I know only the basics of VBA programming.

Thanks in Advance :)
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
Some years ago I used Business Objects to produce text files.
Can then automate Excel to import/ process them by recording macros. etc.
 

kanoor

New Member
Joined
Aug 19, 2008
Messages
5
Thanks for this. I managed to get a code work to open BO and update the excel sheet with an updated query. Now i'm struggling it do the easier job..get it to run on a fixed date and time. I tried the Application.OnTime function but it doesn't seem to be doing the job. I'm sure I have not got it right.Would you be able to tell me if I can get this to work, please?

Sub Auto_Update()
Application.OnTime DateValue("22/09/2009 13:20:00"), "updateBO", DateValue("22/09/2009 13:25:00"), Schedule:=True
End Sub

Thanks
 

Watch MrExcel Video

Forum statistics

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