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 » Macro

	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

Macro

Resolved · High Priority · Version 2003

Reply Mon 3 Nov 2008, 16:28Delegate Pamela said...

Pamela has attended:
Excel VBA Intro Intermediate course

Macro

How to link the macro to the online report server?

For upcoming training course dates see: Pricing & availability

Reply Mon 10 Nov 2008, 17:13Trainer Jacob said...

RE: Macro

Hi Pamela

Thanks for your post though I am not too sure on what you are trying to achieve.

If you can provide us with some more detail on this that will be great.

Regards

Jacob

Reply Tue 18 Nov 2008, 10:54Trainer Rich said...

RE: Macro

Hi Pamela,

As this question has been left unanswered for over a week, the system will automatically mark this query as resolved in the next 5 days if we don't hear from you.

If you still require assistance with this query, please post a reply and we will assist you further.

Thank you.

Rich

Mon 24 Nov 2008: Automatically marked as resolved.

Excel articles

· How To Sort A List Of Vehicle Number Plates In Year Order In Excel 2010
· That's The Wonder Of Autofill
· Want To Get To Grips With The Different SUM Functions In Excel?
· Going Against The Grain With Multiple Radio Buttons In Excel
· How To Learn From Your Excel Mistakes

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

Excel tip:

Naming and Using Constants

Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

From the 'Insert' menu select 'Name', then select 'Define'.

Enter the constant

View all Excel hints and tips