Business Objects 6.5 and Excel 2003

[kanoor]

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

 

[BrianB]

Some years ago I used Business Objects to produce text files.
Can then automate Excel to import/ process them by recording macros. etc.

 

[kanoor]

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