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

[Kent Beveridge]

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.bin