ByDon (Open): Instructions - Ownbey procedure to update the roster and pictures on line, in handbook, and for printing.

Here are instructions for the Ownbey procedure to update the roster and pictures on line, in handbook, and for printing. Creates "Roster and Picture Draft" which is on line at http://donredding.com/ownbey/20060931.pdf and also the updated Handbook on line

To create"Roster and Picture Draft" which is on line at http://donredding.com/ownbey/20060931.pdf

edit the access data base on 5695
file is D:\Data.5695\Data_Access\address5695.mdb
then export the roster to ownbeyroster 2006.xls file,into on 5695 d:\5695data\data_access\ownbeyroster 2006.xls and have to do on 5695 because says cannot export from excel to ownbeyroster 2006.xls on 752
export it as ownbeyroster 2006.xls into 1997-2000 xls format
open 752 excel and open ownbeyroster 2006.xls on 5695 d:\5695data\data_access\ownbeyroster 2006.xls
and save/put into on 752 as ownbeyroster 2006.xls ..\Roster of members for handouts and working\ownbeyroster 2006.xls in G:\!00Data\' Ownbey\Roster of members for handouts and working
Open xls

i. open up on G:\!00Data\' Ownbey\Roster of members for handouts and working the ..\Roster of members for handouts and working\ownbeyroster 2006old.xls on 752 in the directory of G:\!00Data\' Ownbey\Roster of members for handouts and working ownbeyroster 2006old.xls which is the template we keep for previous one on 752 in xls as we want the formatting

ii. select/copy “values”G:\!00Data\' Ownbey\Roster of members for handouts and working from ownbeyroster 2006.xls

iii. Paste Special Values into ownbeyroster 2006old.xls which keeps the format already done from the ownbeyroster 2006old.xls with the new figures from ownbeyroster 2006.xls

iv. then print it to fine print and put on hold til print to fineprint with the pictures

open Word

i. Open hand.htm at ../!handbook/hand.htm/hand.html

ii. Make any corrections or additions to the pictures

iii. be sure to correct both sets of pictures

iv. correct table width on page 20 about to 720

v. get the picture file from hand.html

vi. open file of ..\Pictures of members for handouts and working\Pictures of members for handouts and working.doc

vii. Get pictures from Hand.html and paste pictures back into file just mentioned , adjust or format as needed and save ..\Pictures of members for handouts and working\Pictures of members for handouts and working.doc

viii. Last step should make keeping margins easier

ix. print picture file to fineprint

in fine print now have two files, the roster and the pictures

i. so now pdf print them as 20060931.pdf

ii. and the name 20060931.pdf

iii. ftp it to www.donRedding.com

iv. http:/donredding.com/ownbey/20060931.pdf

v. This is called on the site "Roster and Picture Draft”

Handout /hardcopy for class

Work with above to create twosided handout of pictures and roster and lessons and maybe officers
Instuctions later

Handbook

Put on Ownbey Web Site now with hand.htm open in Word,
We already have copied from above steps from the roster xls file ..\Roster of members for handouts and working\ownbeyroster 2006old.xls on 752 in the directory of G:\!00Data\' Ownbey\Roster of members for handouts and working2
We already have pasted into the roster space in hand.htm
We already have Gone to the Word file open file of ..\Pictures of members for handouts and working\Pictures of members for handouts and working.doc
We already have select/copy pictures in hand.html file and pasted into ..\Pictures of members for handouts and working\Pictures of members for handouts and working.doc
check again adjustments to width of 720 for table that needs it
NEW Update table of contents
NEW update index
print hand.htm to ohb.pdf file
open Chruchsquare for Ownbey edit

i. go to administration and file manager and

ii. upload the ohb.pdf file and ok to overwrite

iii. watch that size stays around 1,245,000 k.

check out links

Files and links include