╨╧рб▒с>■  #%■   "                                                                                                                                                                                                                                                                                                                                                                                                                                                ье┴q ┐bjbjt+t+ AA      ]┌┌┌┌┌┌┌ююююю · ю├╢ИКККККК$yЇmdо┌оb┌┌bbb"┌┌Июю┌┌┌┌Иb&bИ┌┌И p`5rF╟юю4.ИScript creation We have two separate projects both of which involve Star Office (7.0) spreadsheets. Project 1 is to take data from 37 spreadsheets that have been received by email and extract data from specific cells and create a CSV file which will be used to populate a payroll package. Project 2 is to take data from 37 spreadsheets that have been received by email and extract data from specific cells and create a CSV file. These are sales figures which our branches have created at COB, the purpose here is A master spreadsheet will also be required showing the data extracted and there is a requirement to cross-check the data in the master spreadsheet with that from an SQL database Ц any anomalies to be highlighted on the master spreadsheet. We are expanding so the number of branches will grow from 37, both scripts will have either an *.ini file where extra stores can be added or are flexible to incorporate growth. I can provide examples of both source spreadsheets and the format required for the CSV files on request. ef#$░їЎзи¤√√√√√√√√√√√√√ef#$░їЎзи№░В. ░╞A!░"░#Ра$Ра%░ [$@ё $NormalmH H@H Heading 1$дЁд<@&5БCJKHOJQJ<A@Є б<Default Paragraph Font    WZ&<└═  malcolmIC:\DOCUME~1\MALCOL~1.JOL\LOCALS~1\Temp\AutoRecovery save of Document1.asdmalcolm5\\2900_server\Shared\Documents\IT\Script creation.doc @Аxж!55Ї`@GРЗzА Times New Roman5РАSymbol3&Р ЗzА Arial"qИ╨h╩ ▓Ж` ▓ЖЦ\!е└┤┤А20   Script creationmalcolmmalcolm■ рЕЯЄ∙OhлС+'│┘0tРШ░╝╠╪ф°  0 < HT\dlфScript creationcrimalcolmalcalc Normal.dottmalcolm1lcMicrosoft Word 8.0@zеT@tПГёE╟@HрYF╟Ц\■ ╒═╒Ь.УЧ+,∙оD╒═╒Ь.УЧ+,∙о@№ hpАИРШ аи░╕ └ ▄фJollyes 1 Script creation TitleШ 6> _PID_GUIDфAN{F86B9691-5383-4474-8BD6-6D959E772348} ■    ■   ■    !■   ¤   $■   ■   ■                                                                                                                                                                                                                                                                                                                                                                       Root Entry         └FNД╬ХF╟ЁпGrF╟&А1Table             WordDocument        SummaryInformation(    DocumentSummaryInformation8            CompObj    jObjectPool            ЁпGrF╟ЁпGrF╟            ■                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           ■       └FMicrosoft Word Document MSWordDocWord.Document.8Ї9▓q