Sending mail without a security popup
June 4th, 2008 by 
Yaron Assa 
Loading ...This QTip by Naikaparna demonstrates how to send a EMail without initiating any security popups by using CDO, instead of using outlook.
MS Applications
| MS-Access (1) | MS-Excel (7) | MS-Word (11) | Outlook (3) | Visual Studio (1) |
June 4th, 2008 by Yaron Assa Loading ...Read Excel range into an array
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 […]
Get the body of a specific message
April 21st, 2008 by Yaron Assa Loading ...The following code will attach to the Outlook inbox folder, loop through all the unread messages, and search for a message with a specific subject.
If the message is found, it’s marked as read, so we won’t re-find it in future searches.
Retrieving Visual Studio last version
April 1st, 2008 by daniva Loading ...Describes how to automate the Visual Studio .NET IDE from outside the IDE.
Determine which version of access was used to create a database
April 1st, 2008 by daniva Loading ...While looking up something else in the Access documentation we ran across a property named FileFormat. FileFormat is the property that tells us which version of Access was used to create a database. Want to know which version of Access was used to create the database flight32.mdb? ( The flight application’s QTP demo ) Here you go:
Save a Document as an HTML File
April 1st, 2008 by daniva Loading ...Demonstration script that opens a file named C:\Scripts\Test.doc and then saves that file in HTML format
Make your word speak!
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 in MS-Word
Open and print MS-Word document
April 1st, 2008 by daniva Loading ...Demonstration script that opens and prints and existing Microsoft Word document.
Use MS-Word to search for files
April 1st, 2008 by daniva Loading ...Demonstration script that uses Microsoft Word to locate all the .mp3 files stored on drive C of the local computer.
List MS-Word properties
April 1st, 2008 by daniva Loading ...The function accepts a string containing text to be spell checked, checks the text for spelling using MS Word automation model, and then returns the processed text as a string. The MS Word spelling dialog will allow the user to perform available actions in the dialog.
Create and Save a Word Document
April 1st, 2008 by daniva Loading ...Demonstration script that retrieves network adapter data from a computer, displays that data in a Microsoft Word document, and then saves the document as C:\Word\Network Adapter Report.doc.
Create a new word document
April 1st, 2008 by daniva 
Loading ...Demonstration script that creates and displays a new Microsoft Word document.
Apply a style to a table in a word document
April 1st, 2008 by daniva Loading ...Demonstration script that retrieves service data from a computer, displays that data in a table in Microsoft Word, then formats the data by using a predefined Microsoft Word style
Append Text to a Word Document
April 1st, 2008 by daniva Loading ...Demonstration script that appends the current date to the existing Microsoft Word document C:\Word\Testdoc.doc.
Add formatted text to a word document
April 1st, 2008 by daniva Loading ...Demonstration script that displays formatted data in a Microsoft Word document
Add a formatted table to a word document
April 1st, 2008 by daniva Loading ...Demonstration script that retrieves service data from a computer and then displays that data in a formatted table in Microsoft Word
Make your excel speak!!
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.
List service data in a spreadsheet
April 1st, 2008 by daniva Loading ...Demonstration script that displays the various colors — and their related color index — available when programmatically controlling Microsoft Excel
List excel color values
April 1st, 2008 by daniva Loading ...Demonstration script that displays the various colors — and their related color index — available when programmatically controlling Microsoft Excel
Format a Range of Cells
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.
Add Formatted Data to a Spreadsheet
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.
Add Data to a Spreadsheet Cell
April 1st, 2008 by daniva Loading ...Demonstration script that adds the words “Test Value” to cell 1,1 in a new spreadsheet.
Clicking Outlook Security Popup
March 28th, 2008 by Yaron Assa Loading ...If you ever trying sending a with Outlook via "the back door" (e.g. by VBScript), you’ve probably found yourself facing this message :
This can be annoying if you happen to be near the computer, and could turn into a complete disaster if you’re trying to send the email from a QTP script running solo. Because […]
Recent Comments