[Yr7-10it] re : Visual Basic and Excel Macros

[Costello, Rob R]

Hi Kent 

Jenna seemed to be asking for tutes on Excel macros (VBA - Visual Basic
for Applications)  and there doesn't seem to be many easy starters on
that (lots of books and courses though) 

(She might well need both macros (VBA) and stand alone VB6)  

To clarify : if you record an Excel macro (VBA) you get a lot of custom
language and properties which VB6 doesn't understand 

anything you can do in Excel can be controlled through VBA

ie VBA is a VB variant - lots of extra properties and methods that
correspond to how Excel works (commands for formatting cells, running
Excels sort or search routines etc 

so yes VB6 tutes are definitely related - many of the concepts are
transferable - but VBA has a whole stack of extra commands for the
application     

I was meaning there aren't many good introductory Excel VBA tutes 

Cheers 

Rob 

> I beg to differ with Rob, I found quite a few easy to use/learn Tutes
on
> VB6.
> Just make sure you use the right choice of words in the google search.
> Kent.
> 
> Kent Beveridge,
> I.T. co-ordinator
> St. Brigids Catholic Sec. College
> Horsham
> email.. kbeveridge at stbc.vic.edu.au
> 
> |<3|\|7  b3\/3r1D93 ?  ;-)
> 
> Wishes and Eggs, one you make and one you break!  A bit like
promises.....
> "This email and any attachments may be confidential.  You must not
> disclose or use the information in this email if you are not the
intended
> recipient.  If you have received this email in error, please notify us
> immediately and delete the email and all copies.  The School does not
> guarantee that this email is virus or error free.  The attached files
are
> provided and my only be used on the basis that the user assumes all
> responsibility for any loss, damage or consequence resulting directly
or
> indirectly from the use of the attached files, whether caused by the
> negligence of the sender or not.  The content and opinions in this
email
> are not necessarily those of the School."
> 
> ________________________________
> 
> From: yr7-10it-bounces at edulists.com.au on behalf of Costello, Rob R
> Sent: Fri 2/1/2008 1:13 AM
> To: yr7-10it at edulists.com.au
> Subject: [Yr7-10it] RE: Visual Basic and Excel Macros
> 
> 
> 
> Hi Jenna
> 
> There's a lot on the web for this but majority is possibly a bit
beyond
> the initial stage
> 
> I have an idea - I'll try to do a quick screen cast in next day or two
> of using Excel to work like a basic "web bot" - get it to
automatically
> download the content of a web page the user chooses, collate the list
of
> hyperlinks off the page, search for the links that contain certain
> words, and then open a browser to follow the ones it finds - all in
one
> go
> 
> Is that the sort of idea you could maybe use?
> I've done similar before and not very hard to do with the features in
> excel
> 
> Still - depends a bit on what you want the kids to get out of it  -
> macros can be as broad as your ideas really - copy files around,
access
> web, process data etc
> 
> cheers
> 
> Rob
> 
> > Message: 1
> > Date: Wed, 30 Jan 2008 15:13:33 +1030
> > From: Jenna Hubbard <jenna.hubbard at hotmail.com>
> > Subject: [Yr7-10it] Visual Basic and Excel Macros
> > To: "Year 7 - 10 Information Technology Teachers' Mailing List"
> >       <yr7-10it at edulists.com.au>
> > Message-ID: <BLU128-W384760A371D422F34C960FE5360 at phx.gbl>
> > Content-Type: text/plain; charset="iso-8859-1"
> >
> > Hi all,
> >
> > Can anyone send to the list introductory lessons on Visual Basic and
> Excel
> > Macros or have any suggestions on where to start?
> >
> > Thanks,
> >
> > Jenna
> >
> >
> 
> Important - This email and any attachments may be confidential. If
> received in error, please contact us and delete all copies. Before
opening
> or using attachments check them for viruses and defects. Regardless of
any
> loss, damage or consequence, whether caused by the negligence of the
> sender or not, resulting directly or indirectly from the use of any
> attached files our liability is limited to resupplying any affected
> attachments. Any representations or opinions expressed are those of
the
> individual sender, and not necessarily those of the Department of
> Education and Early Childhood Development.
> 
> _______________________________________________
> http://www.edulists.com.au <http://www.edulists.com.au/>  - FAQ,
> resources, subscribe, unsubscribe
> Year 7 - 10 IT Mailing List kindly supported by
> http://www.vcaa.vic.edu.au <http://www.vcaa.vic.edu.au/>  - Victorian
> Curriculum and Assessment Authority and
> http://www.vitta.org.au <http://www.vitta.org.au/>   - VITTA Victorian
> Information Technology Teachers Association Inc
> 
> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: not available
> Type: application/ms-tnef
> Size: 7614 bytes
> Desc: not available
> Url : http://www.edulists.com.au/pipermail/yr7-
> 10it/attachments/20080201/f59ef0ee/attachment-0001.bin
> 
> ------------------------------
> 
> _______________________________________________
> Yr7-10it mailing list
> Yr7-10it at edulists.com.au
> http://www.edulists.com.au/mailman/listinfo/yr7-10it
> 
> 
> End of Yr7-10it Digest, Vol 36, Issue 2
> ***************************************

Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.