Definitive Guide to Excel VBA 2nd Edition
Excel offers right out of the box an enormous variety of functions. So why does one need VBA macros? With VBA you can accomplish wonders: You can program your own worksheet functions that are easier to use than complicated formulas. You can configure Excel to suit your requirements and in this...
Đã lưu trong:
| Tác giả chính: | |
|---|---|
| Định dạng: | Sách |
| Ngôn ngữ: | English |
| Được phát hành: |
Apress
2012
|
| Những chủ đề: | |
| Truy cập trực tuyến: | http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/30975 |
| Các nhãn: |
Thêm thẻ
Không có thẻ, Là người đầu tiên thẻ bản ghi này!
|
| Thư viện lưu trữ: | Thư viện Trường Đại học Đà Lạt |
|---|
| Tóm tắt: | Excel offers right out of the box an enormous variety of functions. So why does one need VBA macros? With VBA you can accomplish wonders:
You can program your own worksheet functions that are easier to use than complicated formulas.
You can configure Excel to suit your requirements and in this way achieve greater simplicity and efficiency.
You can structure and simplify complex processes such as filling out forms by means of "smart" forms (templates).
You can automate processes that are used frequently. This is particularly useful in dealing repeatedly with large data sets that must be processed, analyzed, and graphically displayed.
You can create freestanding Excel programs that display their own menus, dialogs, and toolbars. This makes it possible to simplify an Excel application to the point where those unfamiliar with Excel can run the program correctly. |
|---|