May 1st, 2008 by 
Yaron Assa 
Loading ...Usually, we only want to read some data from an Excel worksheet, and we’ll be more than happy to get that data in a simple 2-dimensional array.
Later we can loop through the array, and access the data in a quick and easy fashion.
Here’s a function which receives an Excel file, the workbook name and returns […]
April 1st, 2008 by daniva Loading ...Microsoft Excel is the only Microsoft Office XP program that has built-in Text to Speech (TTS) capabilities. This tip explains how you can use OLE Automation to programmatically access the Excel object model and use the Text to Speech functionality.
April 1st, 2008 by daniva Loading ...Demonstration script that displays the various colors — and their related color index — available when programmatically controlling Microsoft Excel
April 1st, 2008 by daniva Loading ...Demonstration script that displays the various colors — and their related color index — available when programmatically controlling Microsoft Excel
April 1st, 2008 by daniva Loading ...Demonstration script that adds data to four different cells in a spreadsheet, then uses the Range object to format multiple cells at the same time.
April 1st, 2008 by daniva Loading ...Demonstration script that adds the words “test value” to a new spreadsheet, then formats the cell containing the value.
April 1st, 2008 by daniva Loading ...Demonstration script that adds the words “Test Value” to cell 1,1 in a new spreadsheet.
(9 votes) (5 votes) (5 votes)
Recent Comments