Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - 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 courses london - VBA

Resolved · Low Priority · Version Standard

Reply Wed 23 May 2007, 15:32Delegate Paul said...

Paul has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course

VBA

Can you send automatic messages to a group? E.g. part of the macro sends a e-mail or a pop up message to a group of people (or selected list of machines)

For upcoming training course dates see: Pricing & availability

Reply Tue 12 Jun 2007, 10:09Trainer Andrew said...

RE: VBA

Hi Paul

Thanks for your question - could you give us a little more information about the outcome you are looking for? e.g. the environment your message recipients are operating in (eg version of Windows and if there is a domain, whether there is an Exchange server etc.

Kind regards,

Andrew

Reply Thu 14 Jun 2007, 12:22Delegate Paul said...

RE: VBA (messages)

Hi Andrew

To give you our specific situation. Or team have a list of tasks to be performed eac hday. Once a task is performed the individual "signs off" that it is complete. Once this sign off ouccurs we'd like a message to be sent to the rest of the group ...along the lines of "Task "x" complete byt user "y" at time "t". The following tasks are still outstanding: ...."

Ideally we'd send this by netsend to a specific list of users or machines.

If this isn't possible then Outlook would be OK. We're all on windows XP and on the same domain

Many Thanks
Paul

Reply Thu 14 Jun 2007, 13:13Trainer Andrew said...

RE: VBA (messages)

Hi Paul

Thanks for providing further information. It looks like this would be outside the scope of the support forum and be better handled by one of our consulting team. I will arrange for one of us to give you a call to discuss further.

Kind regards,

Andrew

VBA articles

· Make Office work for you with VBA
· VBA - Not Just For Programmers
· How Passwords Can Preserve Your VBA Macros
· Step Into The Unknown With VBA
· Computer Programming Made Easy With VBA

Vba tip:

Count the Rows and Columns in a Selection

If you need to count the number of rows or columns in a worksheet use the following code:

Selection.Rows.Count - Returns the number of rows in the selection

Selection.Columns.Count - Returns the number of columns in the selection

Selection.CurrentRegion.Rows.Count - Returns the number of rows in the current region of the selection

View all VBA hints and tips