You are viewing this page out of context. To see it in the context it is intended please click here.

About This Page

Reply posted by Francesco Tarantino on Wed 12 Dec 2001 in response to Keeping the boss happy

open a view in excel

I have read this some time ago
(http://www.dominopower.com/issues/issue199901/domexcel001.html), and I've
found more interesting.


Briefly, you can read an HTML table in excel, then a web view, with the web
query tool.
You can deploy this with a excel file, template, or a .iqy file, wich contains
the query parameter.


If you embed the view in a form, and write a table row with formulas like
"=sum(a1:a100)", then you have totals, without write a LotusScript agent.


I love this tool, is a perfect example of power and semplicity.


bye
Francesco


PS: Lotus 1-2-3 also has a similar facility.
PPS: great site, Jack, I love you.