Saturday, April 10, 2010

QTP Scripts - Page 3

QTP Scripts - Page 3

QTP Script 81
VBScript - Appending Data to an Excel Spreadsheet

QTP Script 82
VBScript - Creating Line Charts in Microsoft Excel

QTP Script 83
VBScript - Creating Pie Charts in Microsoft Excel

QTP Script 84
VBScript - Inserting a Formula into an Excel Spreadsheet

QTP Script 85
VBScript - Putting Borders Around Excel Spreadsheet Cells

QTP Script 86
VBScript - Using ADO to Query an Excel Spreadsheet

QTP Script 87
VBScript - Wrapping Text in an Excel Spreadsheet

QTP Script 88
VBScript - Using the Text to Columns Feature in Microsoft Excel

QTP Script 89
VBScript - Using Microsoft Excel to – What’s That? Search for Files!

QTP Script 90
How to set center alignment for an Excel cell using VBScript?

QTP Script 91
VBScript- Reading Data From A Binary File And Loading It Into Excel

QTP Script 92
Very Fast Loading Of Record Set Into Excel

QTP Script 93
VBScript - Excel 2007 - Reading DBF Files At Super Speed!

QTP Script 94
Setting Excel Borders From VBScript

QTP Script 95
Excel: Copy And Paste Cells/Rows/Columns Using JScript/VBScript

QTP Script 96
Column Uniquing In Excel Via VBScript

QTP Script 97
VBScript - Using Excel As A Web Service Client

QTP Script 98
VBScript - Configure Worksheet Center Header (Sets the center header of every worksheet in a workbook to the worksheet name.)

QTP Script 99
VBScript - How Can I Sort Worksheets in a Excel Workbook?

QTP Script 100
VBScript - How Can I Add Additional Worksheets to an Excel Workbook?

QTP Script 101
VBScript - How Can I Locate and Replace Information for a Specific Item in an Excel Spreadsheet?

QTP Script 102
VBScript - How Can I Change All the Lowercase Letters in an Excel Worksheet to Uppercase Letters?

QTP Script 103
VBScript - How Can I Convert a Tilde-Delimited File to Microsoft Excel Format?

QTP Script 104
VBScript - How Can I Tell If a Specified Worksheet Exists in an Excel Workbook?

QTP Script 105
VBScript - How Can I Add a Total Row to an Excel Spreadsheet?

QTP Script 106
VBScript - How Can I Import an Excel Spreadsheet Into an Access Database?

QTP Script 107
VBScript - How Can I Specify the Number of Decimal Places to Display in an Excel Spreadsheet?

QTP Script 108
VBScript - How Can I Replace Text in an Excel Spreadsheet?

QTP Script 109
VBScript - How Can I Insert a Column into a Spreadsheet?

QTP Script 110
VBScript - How Can I Color Every Other Row in an Excel Spreadsheet?

QTP Script 111
VBScript - How Can I Delete All the Worksheets in a Spreadsheet Except for the First Worksheet?

QTP Script 112
VBScript - How Can I Change the Background Color of Spreadsheet Rows That Have a Date in a Specified Cell?

QTP Script 113
VBScript - How Can I Set the Print Area in an Excel Spreadsheet?

QTP Script 114
VBScript - How Can I Open All the Excel Spreadsheets in a Folder and Run a Specified Macro Found in Each of Those Spreadsheets?

QTP Script 115
VBScript - How Can I Delete Specified Rows in an Excel Spreadsheet?

QTP Script 116
VBScript - How Can I Copy Data from Excel to PowerPoint?

QTP Script 117
VBScript - How Can I List the Addresses in My Sent Items Folder in an Excel Spreadsheet?

QTP Script 118
VBScript - How Can I Convert a Number to a Date and Then Back in Excel?

QTP Script 119
VBScript - How Can I Update and Then Break All the Links in an Excel Spreadsheet?

QTP Script 120
VBScript - How Can I Cut a Row From One Office Excel Spreadsheet and Paste That Row Into Another Spreadsheet?

QTP Script 121
VBScript - How Can I Center Text in an Excel Cell?

QTP Script 122
VBScript - Add Data to a Spreadsheet Cell

QTP Script 123
VBScript - Format a Range of Cells

QTP Script 124
VBScript - Open an Excel Spreadsheet

QTP Script 125
VBScript - Add Formatted Data to a Spreadsheet

1    2    3    4    5