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

Costello, Rob R Costello.Rob.R at edumail.vic.gov.au
Fri Feb 1 01:13:27 EST 2008


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.



More information about the Yr7-10it mailing list