Not sure if this helps. It would run from Notes, rather than in Excel.
Otherwise, this is a non-script solution available on Domino Power.
<a href=”http://www.dominopower.com/issues/issue199810/excel001.html”>http://www.dominopower.com/issues/issue199810/excel001.html</a> – This article will show you a — in few simple steps — how to turn a Lotus Notes view into an XML-equipped Web page. This new page can not only be viewed by a Web browser, but opened by Excel 97 — complete with formulas and summed columns. Further, you’ll see how to take one small XML step to condense large amounts of information into flexible Excel pivot tables, and how to use Web agents to work around limitations of Notes views.
Search openntf.org for code that will do that.
The other choice is to select the docs in the view and copy as a table (r7 & up). You can then paste it into excel.
If this is to be done all the time then you can use NotesODBC and have excel pull the data as ODBC, this lets you just do it in excel and not have to export or use com to write directly to excel