vba
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

VBA

resolvedResolved · Low Priority · Version 2003

replyReply Fri 14 Nov 2008, 10:56Delegate Xiaoli said...

Xiaoli has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course

VBA

How to connect VBA to database if we need retrieve data to do function?

For upcoming training course dates see: Pricing & availability

 

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

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard