Last year, I bought 32 laptops for in-class use out of my own money (used- all I could afford) to bring my students into the 21st century. Many companies donated software and hardware. The students were excited and focus. My class had the highest math scores in the district. Now, I want to be more efficient. I’m a good teacher but a poor programmer so I need I need help this summer with VBA modules to build an excel master program.
( I have attached code that someone did for me that will search and bring in files from a single folder. It can be used as a basis or you may have a better routine or other suggestions to make this a nice module.)
Mod 1= summary= Excel sheet1 will have many cells so I can click on a cell to launch (run) a program located on sheet2 plus I need to populate sheet2 with path/filenames. Don’t want to use hypertext because of the address change problems and arguments don’t work on command line
Sheet 1 – Sample – Click on a cell (ie.C1 - math) and it searches on sheet2 (row 51+) for "Math" and launches a program (sheet2 B52) with the filename and any command line arguments.
..A........B............C................D........ ...E
1........To Do.....Math.............Etc.........Etc >>>
2........Etc........Etc................Etc........ Etc >>>
999........Etc.....Etc................Etc........E tc>>>
Sheet 2 – Folders, including any subfolders, to populate this sheet with files (D col) for searching by values in (B1), filtered by only extensions in B2. Place any path/filenames in (D51+), but don’t overwrite if found same path/name but add to end of D Column. Later I will enter (“Name"- A53+) and also on sheet 1 (C3+) so they can be clicked on.
..... A.......... B ................................C................. .......D................................E
1..Folders ....C:\Fold1\, D:\Fold2\, etc
2..Extens......Swf, PPt, PPs, Mp3, Mp4, etc
5..Doc......C:\Word.exe
6..Mp4......D:\Vlc.exe
7..etc
8..etc
50..Name ...Launch this.......... Launch Prog................Launch File..........................Launch Arg
51..To Do....C51+D51+E51......C:\word.exe...............C :\Fold1 C:\todo.doc
52..Math.... D52+D52+E52 ......D:\Vlc.exe.................D:\Fold2\Math.mp 4........--Repeat --F2
53..Etc.
Any and continuous help this summer on this project will be very much appreciated as I can’t do it on my own. If you would like to see a newspaper article about my Pilot Program, please email (subject line="I can give some limited help”) to Sloan at Cox dot net. Thank you
Bookmarks