Quick Links ▼

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

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Summary V4 from VBA Intro training

	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

Summary V4 from VBA Intro training

Resolved · Low Priority · Version 2003

Reply Wed 13 Apr 2011, 10:41Delegate Victoria said...

Victoria has attended:
Excel VBA Intro Intermediate course

Summary V4 from VBA Intro training

Hi

I went on the VBA training for 2003 yesterday (12 April) and have a problem on the Summary V4 of the training.

It is due to the final part of the sub main:

Sub AllDoneAndDusted()
Application.Speech.Speak "All done and dusted - he ha he ha"

Does anyone else have the problem that their computer doesn't like this - it comes up with a 'Run-time error '1004'
Application - defined or object -d defined - error'

any help appreciated.

Thanks
Victoria

For upcoming training course dates see: Pricing & availability

Reply Mon 18 Apr 2011, 10:48Trainer Stephen said...

RE: Summary V4 from VBA Intro training

Hi Victoria

Thanks for the question

I have run this code and all seems fine. Can you confirm that the code breaks at the above line? If so, what version of Excel are you using. It might also be worth checking that you have a full installation of Microsoft office

Thanks

Stephen

Reply Wed 20 Apr 2011, 14:58Trainer Simon said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Reply Wed 20 Apr 2011, 16:31Delegate Victoria said...

RE: Summary V4 from VBA Intro training

Thanks I think it is probably an issue with my microsoft office as it definitely breaks at that point.

Thanks
Victoria

Excel articles

· Excel: Save Time With AutoFill
· How To Disguise Error Messages In Excel 2007/2010
· Charting Another Dimension With Excel
· How To Take Your Data Out Of The Shade
· Save time with Microsoft Excel

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

Excel tip:

Keyboard Shortcuts to Add Rows or Columns

Couple of other keyboard shortcuts. Shift+spacebar selects a row, Ctrl+spacebar selects a column. Select either row or column (or several) and use Ctrl and + to insert or Ctrl and - to delete rows or columns.

View all Excel hints and tips