1 / 14

情報基礎 A Lecture 15

情報基礎 A Lecture 15. Takeshi Tokuyama Tohoku University Graduate School of Information Sciences System Information Sciences Design and Analysis of Information Systems. Programming VBA Data Processing plus. Chart Insertion. Procedure Call. Calling procedure from different procedure

meredith-walters
Télécharger la présentation

情報基礎 A Lecture 15

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 情報基礎ALecture 15 Takeshi TokuyamaTohoku University Graduate School of Information SciencesSystem Information SciencesDesign and Analysis of Information Systems

  2. Programming VBAData Processing plus

  3. Chart Insertion

  4. Procedure Call • Calling procedure from different procedure • Procedure already written • Sub sum_ave_6sub() • Sub grade_6sub() • Sub student_ave() • Sub stat_pass_fail() • Sub stat_grade() • Sub chart() • Instead of executing each procedure, write a new procedure to call all of them

  5. Procedure Call • Write procedures to execute in Sub score() • Call “Procedure name” • Six procedures are executed in order

  6. Process 20 files at once

  7. Preparation • Download “hogehoge”

  8. 20 Data File and Statistics File

  9. Exercise • Score data processing for 20 classes • Execute six process below for each file • Sub sum_ave_6sub() • Sub grade_6sub() • Sub student_ave() • Sub stat_pass_fail() • Sub stat_grade() • Sub chart() • Procedure name: score() • Output statistics of 20 classes into score.xls

  10. File Operation • Open method • Open 20 files in order • Utilize number in filename as a variable • Save and close active file

  11. Accessing the other file:Copy data to a file • Copy the number of student who got “A” for Japanese on sheet “Statistics” to score.xls->sheet:2011->Japanese->A • Copy a cell B4 on sheet “Statistics” of active file to a cell B3 on score.xls

  12. Copy a path \\netsrv22\c90a1rlu\MyDocuments\foo\bar\baz.xls

  13. Submit

More Related