程式VBA指南對於Excel應用,VBA編輯器提示,一些Excel的VBA語言的基礎和關鍵功能 限時免費推廌app
Reference

VBA Guide For Excel
 +  iPhone app / iPad app 雙系統版本
Optimized for iPhone5
View In iTunes
原App Store內容轉載:
   
  
VBA Guide For Excel explains some of the basic and key functions of Excel VBA and also contains handy sample Excel macros for whenever you may need them when building projects in Excel.

There are several Excel macro's in this app that show you how to send an email, how to find the last modified file in a folder and many more.

The macro examples pages have images which can be shown by swiping the text to the right.

Example macros can be exported via:
- Email in message body
- Email with .txt attachment
- Exported as .txt file to other compatible apps on your device.
- SMS
- Print (via AirPrint)
- Copy the code to the device's clipboard.

Guide Page:
> Cell Navigation
> Sheets & Workbooks
> Variables
> If Statement
> Select Case Statement
> Error Handling
> Loops
> Worksheet Functions
> Custom Functions
> References
> Offset Function
> Message Box
> Delay & Wait
> Single Dimension Array
> Date and Time
> VBA Editor Tips
> Debugging

Example Pages: All with export options
> AutoFilter - Copy
> AutoFilter - Delete
> Clear Pivot Table Cache
> Count Files In Folder
> Download Files
> Email - Advanced
> Email - Basic
> Email - Sheet
> Email - Range to HTML
> File Properties
> Find Last Modified File
> Lookup
> Loop through Files In Folder
> Create and/or Open Folder In Explorer
> Open (and interact with) Internet Explorer
> Open (and add data to) MS Word
> Get PC or Windows Username
> Replace Characters
> Screenshot (save as an image)
> Read and Write .txt files
> Zip Folder - Add Files
> Zip Folder - Extract Files
> Database - Create
> Database - New Record
> Database - Find Record
> Database - Update Record
> Database - Delete Record


Universal app compatible with iPhone and iPad.

Please leave a review. All feedback is welcome and can be sent from within the app.