Saturday, April 10, 2010

QTP Scripts - Page 4

QTP Scripts - Page 4

QTP Script 126
This VBScript code tells you if Excel is running, and makes the first instance it finds, visible.

QTP Script 127
VBScript - List Excel Color Values (Demonstration script that displays the various colors -- and their related color index -- available when programmatically controlling Microsoft Excel.)

QTP Script 128
VBScript - Read an Excel Spreadsheet (Demonstration script that reads the values stored in a spreadsheet named C:\Scripts\New_users.xls.)

QTP Script 129
VBScript - AutoFit Columns in a Microsoft Excel Worksheet

QTP Script 130
VBScript Sort an Excel Spreadsheet on Three Different Columns

QTP Script 131
VBScript - Sort a Microsoft Excel Worksheet

QTP Script 132
VBScript - Apply an AutoFormat to an Excel Spreadsheet

QTP Script 133
VBScript - Use ADO to Query an Excel Workbook

QTP Script 134
VBScript - Export Microsoft Access Tables to Excel

QTP Script 135
VBScript - Use SQL Commands to Query an Excel Workbook

QTP Script 136
VBScript - Add a Macro to an Excel Spreadsheet

QTP Script 137
VBScript - Connect to/Start Microsoft Excel

QTP Script 138
VBScript - Verify That an Excel Worksheet Exists

QTP Script 139
VBScript - Delete duplicate rows in excel using advanced filter

QTP Script 140
VBScript - Add many formulas to an excel worksheet with one command

QTP Script 141
VBScript - Open User Form in Excel

QTP Script 142
VBScript - Reverse the order of columns in an Excel Worksheet using Sort

QTP Script 143
VBScript - Create a Basic Pivot Table Report

QTP Script 144
VBScript - Create User Accounts Based on Information in a Spreadsheet

QTP Script 145
VBScript - Retrieve Computer Information from an Excel Spreadsheet

QTP Script 146
VBScript - How Can I Remove the Password When Opening an Excel Spreadsheet?

QTP Script 147
VBScript - Verify That an Excel Worksheet Exists

QTP Script 148
VBScript - How Can I Replace Numeric Values in an Excel Spreadsheet?

QTP Script 149
VBScript - How Can I Password-Protect an Excel Spreadsheet?

QTP Script 150
VBScript - How can I asign background color to excel cell?

QTP Script 151
VBScript - How Can I Save a Table in an Access Database as a Spreadsheet?

QTP Script 152
VBScript - How to convert excel to XML format?

QTP Script 153
VBScript - How Can I Copy Column C of One Worksheet to Column A of a Second Worksheet?

QTP Script 154
VBScript - How can I read text file to excel?

QTP Script 155
VBscript - How Can I Create a New Excel Spreadsheet at Midnight Each Night?

QTP Script 156
Select All the Formula Cells in a Worksheet

QTP Script 157
VBScript - Excel Individual Cell Protection from Changes without protecting the worksheet

QTP Script 158
VBScript - How to add a macro to excel spreadsheet?

QTP Script 159
VBScript - How to convert CSV file to Excel and preserve format?

QTP Script 160
VBScript - How to convert an excel file to CSV file?

QTP Script 161
VBScript - How to add COUNTIF formula to an excel spreadsheet?

1    2    3    4    5