Macros--tutorial.jcwcn.com

home / Business-Applications / MS Excel / Macros

this：1/1 25records total:11 start Previous Next Last goto:

How To Get the Weekday as Text in Excel VBA: ON: 2009-07-20 08:43:32; This tutorial explains how to get the weekday as text in Excel, using VBA, and giving a function to do the job. We also give a method which avoids using macros, for comparison.; 2 times | category:

VBA: Find Text in a String (instr): ON: 2009-07-20 08:39:22; You can use the instr function in VBA to test if a string contains certain text. The result is the number of times the specified text appears in the string.; 4 times | category:

Removing #DIV/0! errors from your spreadsheets: ON: 2009-04-21 12:52:14; Shows how to remove #DIV/0! errors from your spreadsheets permanently using the AssumeIT macros; 11 times | category:

Insert Data from Excel to SQL Server: ON: 2008-12-30 11:24:26; Shows how to read data from an Excel spreadsheet and insert it into a SQL Server database using VBA and ADODB.; 42 times | category:

Prevent Users from Performing Certain Actions In Excel: ON: 2008-09-02 09:46:50; protect your excel file by preventing user performing certain action like save as and printing; 26 times | category:

Extract Data from a Corrupt Workbook in Excel 2007: ON: 2008-09-02 09:45:59; This tutorial is about Extract Data from a Corrupt Workbook in Excel 2007; 20 times | category:

Create a toolbar button for an existing macro: ON: 2008-09-02 09:44:44; Step by step instructions with screenshots on how to create a toolbar button for an existing macro in excel. This a great little time saver when working with macros.; 12 times | category:

Macros {Tutorial for beginners}: ON: 2007-08-30 11:32:20; In this tutorial, you will learn how to create and use Excel’s macros....; 511 times | category:

Edit a Macro Using Microsoft Visual Basic in Excel: ON: 2007-08-30 11:30:45; Learn how to easily edit a macro using visual basic in Excel. Instead of creating a macro for everything you want to automate, just edit an existing macro. Screenshots included.; 694 times | category:

How to Create a Simple Macro in Excel: ON: 2007-08-30 11:22:45; Learn to create a simple macro in Excel using step by step instructions with screenshots.; 713 times | category:

Macros Tutorial: ON: 2007-08-30 11:16:38; Macros make it wonderfully easy to automate repetitive tasks in Excel, but the way they're created and the facilities for using them are sometimes problematic. Fortunately, Excel is flexible enough that you can fix those problems and create new features with a minimum of effort.; 415 times | category:

this：1/1 25records total:11 start Previous Next Last goto: