Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
litLIB demo: Cockpit spreadsheet (Read 4025 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
litLIB demo: Cockpit spreadsheet
16.08.08 at 16:33:30
litLIB demo: Cockpit spreadsheet
To show how easy it is to make a cockpit spreadsheet I have created this topic and attached the demo spreadsheet: cockpit.xls.
I wanted to create a cockpit showing the current stock market indexes, the free space on my C drive and my PC's free memory.

To retrieve the infomation from a webpage the =Webpage function is used. On the site the main world indexes are found:
Using the string functions Instr and Mid I retrieve the value. Converting it to a number the ToDouble function was used.
To get the number of free bytes on the C drive the DiskFreeBytes function was used. The memory status was displayed using the MemoryTotal, MemoryFree and MomoryUsed functions.
Back to top
« Last Edit: 16.08.08 at 16:41:19 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1