Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft excel

ResolvedVersion 2003

Charlotta has attended:
Excel Advanced course

Microsoft Excel

Can I record a macro linked to SQL?

RE: Microsoft Excel

Hi Charlotta

Thanks for your post, the short answer is yes! What you need to do specifically and how you go about it is naturally a bit more involved.

We can either take the consultative approach where you send us a sample file of what you are working on togther with a brief of key objectives.

We review this and let you know if we can assist, the scope of work and related costs.

An alternative maybe for you to look at our Excel VBA & Excel VBA Advanced courses so that you can "grow" your own knowledge and thereby bulid your solution.

links to course info:
https://www.stl-training.co.uk/excel-course-in-london-2003-vba.php
https://www.stl-training.co.uk/vba-training.php

If you would like to look at the consultative appraoch please do get in touch.

Regards

Jacob

Thu 4 Dec 2008: Automatically marked as resolved.

Excel tip:

Quick Absolute Cell References

When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.