Start to learn Visual Basis to boost your productivity with Excel

MS Excel (and other Office software) is a powerful tool from MS. It would be much better if you know to use Visual Basic programing language to program every task you need to do.

For a beginer, I recommend the function of Recording, which automatically generate the VB code for each action you do with the work book.
I found this is a very sexy way to learn VB programing, which is really practical and easy to go to your mind.
OK here we go:
(0. You should add tab Developer if you want to work a lot with VB & macro)
1. Create new macro and start recording.
2. Open the VB editor.
3. Do something in your workbook; the code will be generated in the Editor.
4. Lear how to PROGRAMING.

Have funny time with VB coding!

---V---

Nhận xét

Đăng nhận xét

Bài đăng phổ biến từ blog này

[sapui5] Best Practice in sapui5 development

Hình ảnh
Hi, Small Tips but no many knows: - Use this.getResouceBundle().getText(sKey, aParam) - Use BaseController (instead of creating a Util service). - Odata Model resetChanges() & submitChanges() ('TwoWay' binding required). Allow TAB to navigate within a table: Use property " keyboardMode " of ListBase . Set it to value " sap.m.ListKeyboardMode.Edit " and it would allow users to use TAB to move to the next cell in a table (the same behavior in MS Office table). API: https://sapui5.hana.ondemand.com/sdk/#/api/sap.m.ListBase/controlProperties https://sapui5.hana.ondemand.com/sdk/#/api/sap.m.ListKeyboardMode/overview References Advanced JS technique to shorten your code: Below hand-on with explanation will help you to shorten your frontend code a lot. Make the code more succinct, readable & easier to maintain. Functional Programming for your UI5 Apps Hands-On Worksheet Keep in mind the mindset: Think "everythin...
Đọc thêm

Implement Search field with case-INSENSITIVE by SAP UI5

Hello guys, Continue to read if you're sapui5 developer, or you work closely with UI development. At the time I write this post, SAP UI5 and Odata does not support filter with case sensitivity. Odata provide some filter parameter that help you to filter with case-INSENSITIVe. However, you hardly modify the URI of ODATA service in your font end SAP UI5 code. Most of us use API provided from SAP , we only provide the parameter to API function, then let the API from SAPUI5 library handle the ODATA service URL. In short, I mean we cannot, or hardly, modifying the odata GET request as we want, but use the standard API instead. Return to the main topic, we need to write a function to filter the ODATA get request so that we get the returned data filtered as the way we want (filter with case-INSENSITIVE). For example: you type " test " in the search field, then you should get the results with all the entries containing "test", or "Test", or "TES...
Đọc thêm

[sapui5][abap] Use Eclipse to push code to ABAP repository (temporary)

Hình ảnh
Hi, For now, local SAP Web IDE cannot be used to push code to ABAP repository. So we have to use Eclipse as a workaround. This post we will make a tutorial to do that. 1. Setup Eclipse environment: - Get Eclipse as described in this link . - If your company use firewall, you may have an error connecting to the Internet when "Install new software...". In that case, please use network proxy to access the internet ( should ask your IT department the proxy server information ): You can check whether the software gets installed or not by checking in Help/About : 2. Connect to ABAP repository using SAP GUI: Make sure that the connection is ready & on so that you can connect easily using Eclipse. - Open SAP GUI. - Check if your connection is working, if not; create a new connection to your server: Create new connection Input server information to connect to NOTE: in case your eclipse still cannot see the connection (eg. C46), you need to m...
Đọc thêm