Microsoft course Study Notes

2006 October 11, August 05, AM
VBA learning notes under word
========================================================== ====================================
Refer to "VBA development under word" by Chen Rui
========================================================== ====================================
1. VBA Introduction: A Programming extension embedded in office. Understand the relationship between VB, VBA, and VBScript.
2. vbasdk with MS can add VBA control in its own software.
3. The simplest VBA operation is recording macros. During macro recording, your operations will be retained faithfully to generate a large number of redundant code, which requires us to clear some work.
4. The resources of VBA are managed by project, including templates and codes.
5. The command window can quickly execute code and output some interesting content. For example
? Activedocument. Tables. Count
You can directly output the results in the Command window.
6. Create a New VBA to start with the recording macro. Here, we can merge the first row of all tables in the file, and then center and bold the text. After recording a macro, you can read the macro record immediately. If you encounter an object or operation that you cannot understand, you can use Ctrl + F1 to call up quick help. The following is a sample code:
'Yankchina @ gmail.com 2006-08-05
'Mr Chen's VBA development under word'

Dim t as table

For each t in activedocument. Tables
'Circular operation table'
T. Rows (1). cells. Merge
T. Rows (1). Cells. Range. ParagraphFormat. Alignment = wdAlignParagraphCenter
T. Rows (1). Cells (1). Range. Bold = wdToggle
Next

Click a different process in VBA to run the process only.
7. Word object model is the basic knowledge of VBA operations and requires the knowledge structure of OOP.
8. Create an Office object in Word. You can use
Set olApp = CreateObject ("outlook. application ")
The example of Chen Rui is great. In this example, you can create an Outlook contact Based on the table in Word. I can create a VBA script based on this example to create an Outlook contact table in Word. You can also write VBA in Outlook to automatically send Email information based on the table in Word.
========================================================== ====================================
I want to collect some automation requirements in my daily work, and then program them using VBA or. Net.
========================================================== ====================================
Study Notes for programmer 2006
========================================================== ====================================
This is the last episode of Microsoft WebCast, which looks back at 2005 and looks forward to 2006.
1. Microsoft's new Certification System
2. There is an ScoreReportAndLearningPlan on the Microsoft website, which can be used for personal skill testing.
3. Microsoft E-Learning free training materials/videos.
========================================================== ====================================
Study Notes on Visual Studio teamsystem
========================================================== ====================================
1. Methodology + tools
(1) There are laws to follow: XP, RUP, MSF...
(2) mandatory tools: BugManagerSystem and SourceControl
(3) strict law enforcement: integration and integration of various tools
(4) Violations: Enterprise Management System
2. You can download Microsoft's MSF document to learn some Microsoft Project development experience.
3. There are MSF templates in the VSTS, which can be automatically organized to the level of cm3. This indicates that the software development system in Microsoft is completely information-based. (Currently, many of the software development teams and development projects I have seen are still hand-managed, so strange things are that they do not use automated software systems to create automatic projects)
4. Use Excel in VSTS to manage project requirements (Title/Kind/State/Priority). Refer to the MSF document to determine its structure.
5. Import the Excel requirement to the Project and arrange the Project in the Project. Remember that you can directly import an Excel file from the previous Project.
6. The architect mainly designs the architecture and issues logic implementation to the code designer.
7. The project manager can access the project progress through VSTS, or view the project progress from the team's website.
8. The class diagrams in VisualStudio2005 are more in line with the features of the. NET language.
9. A NUnit member is added to MS. In this way, the NUnit unit test framework is generated in VSTS. In addition, you can see the test results through the background of the Code, rather than whether a test function passes the test (Cool unit test ).
10. You can use Shelve in VSTS to suspend code on the server.
11. The code can be statistically analyzed in VSTS. You can also use custom rules to check the naming rules of team code.
12. There are different test projects in VSTS, such as LoadAndStressTest/ManualTest/UnitTest/WebTest. It also provides a virtual testing environment, so that you can build testing in different hardware and software environments, such as Win98, Win2000, and WinXP. You can easily generate charts and find software bugs and bottlenecks.
13. The brisk software development process included in MSF4.0 is the focus of my current learning.