You can open excel in QTP by using the following command

Document libraries consist of your core documents. An example would be a word document,
excel, powerpoint, visio, pdf, etc. Form libraries consist of XML forms.

Office Outlook 2007 provides bidirectional offline synchronization with SharePoint document
libraries, discussion groups, contacts, calendars, and tasks.

vabnix.page.tl
Microsoft Office Groove 2007, included as part of Microsoft Office Enterprise 2007, will enable
bidirectional offline synchronization with SharePoint document libraries.
Features such as the document panel and the ability to publish to Excel Services will only be
enabled when using Microsoft Office Professional Plus 2007or Office Enterprise 2007.
Excel Services will only work with documents saved in the new Office Excel 2007 file format
(XLSX).

SharePoint data can be opened with Access and Excel as an external data source. Thus, SharePoint
can be referenced as an external data source. SharePoint itself cannot reference an external data
source.

The document view architecture was introduced in MFC 2.0. In this architecture the application's data is represented as a "document" object and the views of this data are represented as "view" objects. E.g. If you create an excel document what you see to get your job done i.e. cells, values, etc comprises the view and when you save this data it gets saved as a document. The various views of this document is as a table, graphs, bar charts, etc. The data is stored in a document object. The class representing the document object is CDocument. The sole purpose of this class is to manage an application's data. Views server two purposes: renders visual representation of data stored in document and translate the user's inputs into commands that operate on the data in the document. The class for view is CView. Thus the division of work in terms of data and view helps in work division, better productivity and reusability of code.

Yes, I do. A macro is intended to help automate some of the redundant computations and processes by recording it under a macro name. An example would be a s series of formulas that you record and assign under one macro. All you need to do is to call on that macro when needed.