[mso] Re: simple macros
- From: "Glenda Wells" <gwells@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 10 May 2005 15:17:05 -0400
What I usually do is use the macro recorder to record the steps. If
"All of the different items mentioned are already created..." turn on
the marcro recorder then do them in the order you want them to happen.
Here's a minor tutorial on the marcro recorder:
http://www.helpwithpcs.com/tipsandtricks/microsoft-excel-macro-tutorial.
htm
And another on using VBA:
http://www.exceltip.com/category.html#6
And here's how to create your first macro and lots of other good
reference:
http://www.anthony-vba.kefra.com/vba/vbabasic1.htm
-----Original Message-----
From: Joyce West [mailto:joywestuk@xxxxxxxxxxx]=20
Sent: Tuesday, May 10, 2005 03:00 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] simple macros
Can anybody recommend a good article on creating simple macros for Excel
(and Word maybe).
I wish to create a macro in Excel that will read a front page where
details of a customers order, and various delivery dates etc have been
entered, that will automatically
*print a fax to the distributor with details of requirements *Print
large pallet cards (the number of cards determined by the front page
entered details.
*print a delivery ticket to the customer and dated *print out a copy
sheet with all of these instructions recorded.
All of the different items mentioned are already created on worksheets
within the workbook with various blank sections for the entered details.
I am using Excel 2000
Totally unable to get to grips with MS Help and could do with a decent
tutorial sheet.
Any help would be appreciated
Norman West
I really cannot get to grips with MS help page and really feel that=20
=09
___________________________________________________________
How much free photo storage do you get? Store your holiday snaps for
FREE with Yahoo! Photos http://uk.photos.yahoo.com
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
