VBA Question

[tycanis]

Is it possible to write a macro that access Business Objects to pull information into a spreadsheet?

I can only access this information through Business Objects and want to be able to gather the info every hour. I was think a web query might work. Any ideas?

 

[JamesW]

Hi there,

There are some interesting guides on google. First link from searching:

http://www.tek-tips.com/viewthread.cfm?qid=379294

 

[tycanis]

Thanks. I had not thought of doing a search because when it comes to VBA there is so much to dig through.

However, the Business Objects that I use is based on the web. I do not have the actual program and access it through a url and the employer's intranet. Any ideas?