计算机与现代化 ›› 2011, Vol. 193 ›› Issue (9): 195-198.doi: 10.3969/j.issn.1006-2475.2011.09.052

• 应用与开发 • 上一篇    下一篇

基于Excel VBA 的数码照片著录模板的设计与实现

林慕婵,蔡颖   

  1. 华南农业大学,广东 广州 510642
  • 收稿日期:2011-05-09 修回日期:1900-01-01 出版日期:2011-09-22 发布日期:2011-09-22

Design and Implementation of Digital Photos Cataloging Template Based on Excel VBA

LIN Mu-chan, CAI Ying   

  1. South China Agricultural University, Guangzhou 510642, China
  • Received:2011-05-09 Revised:1900-01-01 Online:2011-09-22 Published:2011-09-22

摘要: 档案管理中,诸如数码照片、实物、设备、学生学籍、人事档案管理等,都有图像与其属性信息图文一体显示于同一窗体中以方便查看或著录的需求,但Excel内置的记录单和一般通用型管理系统都未能提供图文在同一界面上方便著录的功能,本文探讨一种基于Excel VBA的数码照片图文一体著录界面的实现方法。

关键词: Excel VBA, 数码照片, 著录模板, 设计与实现

Abstract: During archive management, there are always relevant graphic that textually integrate with the attribute information of stuffs such as digital photos, material objects, devices, school rolls, HR archives management and so on. Both the graphics and text will be displayed within the same window in order to satisfy the requirements for being viewed or recorded. However, the builtin record sheet of Excel and the normal general management system can not offer the function as discussed above. This paper probes into a method that can be used for acquiring the record interface with both graphics and text of digital photos based on the VBA of Excel.

Key words: VBA, digital photos, cataloging templates, design &, implementation

中图分类号: