Working and linking with other external applications in Excel VBA

-

Comments

Post a Comment

Popular posts from this blog

VBA Developer - Digitally sign your macro project

-
Image
Digitally sign your macro project This article describes how you can digitally sign a macro project by using a certificate. If you don't already have a digital certificate, you must obtain one. To test macro projects on your own computer, you can create your own self-signing certificate by using the Selfcert.exe tool. Obtain a digital certificate for signing You can obtain a digital certificate from a commercial certificate authority (CA) or from your internal security administrator or information technology (IT) professional. To learn more about certificate authorities that offer services for Microsoft products, see the list of  Microsoft root certificate program members . Your macro projects and Microsoft Office Because a digital certificate that you create isn't issued by a formal trusted certificate authority, macro projects that are signed by using such a certificate are known as  self-signed projects . Microsoft Office trusts a self-s...
Read more

Distribute your VBA project to other Microsoft Users

-
We often spend a lot of time to write VBA code to assist us in completing tasks in Microsoft Applications whether an Excel spreadsheet, Access database, Outlook Message, Word Document. This code can be used by other users on the same scenario. We can make our code available to other users. This code can be protected to ensure integrity. The procedure below describe how to create distributed software for an Excel application. The process for other Microsoft applications will be similar. 1. Once you have completed, debugged and tested your program and are happy that it works, protect      your code as follows: Right click on your module or project name and select VBAProject Properties. Assume your sub name is "ProtectedCode" In the General Tab type in the name of your project e.g. "CodeForDistribution". In the Protection Tab select Lock project for viewing  and enter a password for your project. Click on OK. 2. Save your project but select the file type...
Read more

Shortcut keys for VBA coding

-
1. Display the immediate window: Control + G. This window is giving the result of debug.print commands 2. Auto Complete Word: Control + Space This invokes intellisense A further press of the Tab key will select the highlighted word If the Spacebar key instead of the Tab key is pressed it will add a space after selecting the highlighted word. 3. View the Watch Window: Alt + V + H 4. Tab: To move lines of code to the right (Indent). 5. Shift + Tab: To move lines of code to the left (Out dent). 6. Shift + F2: Get the definition of the item under the cursor. 7. Ctrl + Shift + F2: Go to the last cursor position. 8. Alt + F11: Switch between Excel and the VBA Editor. 9. Ctrl + R: View the Project Explorer Window. 10. Ctrl + Shift + 8 (or Ctrl + *): Get the current region on a worksheet. 11. F4: View the Properties Window. 12. F5: Run the code from the current sub. 13. F8: Step into the code. 14. F9 (or click left margin): Add a breakpoint to pause the code. ...
Read more