Problem solve Get help with specific problems with your technologies, process and projects.

What components do we need to make our VB program generate our Oracle reports in Excel?

We have a corporate solution that launches in Unix (Oracle database). Our reports were designed the traditional and hard way. They are sent directly to the printer and the users are unable to manipulate or convert them to graphics. We are now planning to generate them in Excel. Users will continue to request the report by Unix through a VB GUI but the final presentation will be in Excel. A Visual Basic program collects the contents of the report. What are the main components that we will need to do this? Will we need some new Excel application, like Excel Report Builder? What sub-routines will we need to introduce in our current VB program?
There's not enough information in your question for me to answer the question completely. However, to get started, I'd strongly suggest you look at Visual Basic for Applications (VBA), which is part of Microsoft Excel. You can access all the data components you need through Oracle's OLEDB drivers so you can do all the data manipulations you could ever want.

Dig Deeper on Enterprise infrastructure management

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.