Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

VBA

Resolved · Low Priority · Version 2003

Reply Thu 11 Jun 2009, 16:30Delegate Rezaan said...

Rezaan has attended:
Excel VBA Intro Intermediate course

VBA

Are there any pre-existing codes/add-ins which come standard within excel VBA?

For upcoming training course dates see: Pricing & availability

Reply Tue 16 Jun 2009, 17:14Trainer Simon said...

RE: VBA

Hi Rezaan,

Thank you for your question.

I am not aware of any pre-existing code/add-ins that come standard with Excel VBA. When you use the Object Browser to search on Classes, by selecting an event, procedure or method you can get help on it which gives you sample code you can use.

However if you produce a procedure, you can then save it as an add-in and other people can attach that add-in to their Excel application.

I hope this answers your question.

Regards

Simon

Tue 23 Jun 2009: Automatically marked as resolved.

Excel articles

· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· The Secret Formula To Creating Correct Calculations In Excel
· Update Your VAT Rates In Excel
· How To Use The Research Functionality In Excel 2010
· Utilise the web's information banks with Microsoft Excel

Please browse our web site to find out more about
advanced+excel+course and other Microsoft training courses.

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips