VBA Guide For Excel 4+
michael webb
專為 iPad 設計
-
- $60.00
截圖
簡介
"VBA Guide For Excel really delivers very useful and simplified content for those who do not know this programming language, making you increasingly more efficient at using Microsoft Excel. If you are a regular user of this software, I would highly recommend downloading this app on your iPhone or iPad for easy reference."
- AppPicker.com
VBA Guide For Excel explains some of the basic and key functions of Microsoft Excel VBA and also contains handy sample Excel macro's 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 macro's can be exported via the iOS share sheet.
Guide Pages:
> Cell Navigation
> Sheets & Workbooks
> Variables
> If Statement
> Select Case Statement
> Error Handling
> Loops
> Worksheet Functions
> Functions
> References
> Offset Function
> Message Box
> Delay & Wait
> Single Dimension Array
> Date and Time
> VBA Editor Tips
> Debugging
> Events
> Collections
> Screen Updating
> SendKeys
> OnTime Function
> Subroutines
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
> Last row or column
> 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
> Get Email info from Outlook
> Open Any File
> Files and Folders - Copy
> Files and Folders - Move
> Files and Folders - Delete
> Shell Commands
Universal app compatible with iPhone and iPad.
On Facebook, like the 'VBA Guide for Excel' page for the latest news and updates.
Please leave a review. All feedback is welcome and can be sent from within the app.
新內容
版本 5.0
- Rebuilt from the ground up in Swift and with a new design.
- Supports dark mode (iOS 13.0+).
- All images in the guide pages are from the latest version of Excel.
評分與評論
可以學到一些新用法
可以學到一些新用法
作者有用心在經營興更新
App 隱私權
開發者「michael webb」指出 App 的隱私權實務可能包含下方描述的資料處理。如需更多資訊,請參閱開發者的隱私權政策。
不收集資料
開發者不會從這個 App 收集任何資料。
隱私權實務可能因你使用的功能或你的年齡等因素而有所不同。進一步瞭解
資訊
- 供應商
- michael webb
- 大小
- 16.5 MB
- 類別
- 參考
- 相容性
-
- iPhone
- 需要 iOS 12.0 或以上版本。
- iPad
- 需要 iPadOS 12.0 或以上版本。
- iPod touch
- 需要 iOS 12.0 或以上版本。
- Mac
- 需要 macOS 11.0(或以上版本)以及配備 Apple M1(或以上版本)晶片的 Mac。
- Apple Vision
- 需要 visionOS 1.0 或以上版本。
- 語言
-
英文
- 年齡分級
- 4+
- Copyright
- © Excelpanda
- 價格
- $60.00
支援
-
家人共享
啟用「家人共享」,即可讓最多六名家庭成員使用此 App。