How Do You Use Visual Basic To Control Access, Excel And Word?
Visual Basic has now launched Visual Basic for Applications or VBA. This program allows you to control virtually all aspects of Access, Excel and Word. It also allows you to manipulate one of the programs while in another. Follow these steps to learn how to use Visual Basic to control Access, Excel and Word. Use Visual Basic to control Access, Excel and Word by clicking on “Tools” on the program toolbar. Select “Macro” then “Record New Macro.” This is where you can enter the commands in Steps 2 through 5. Program the present date in Word by entering the following code: “Sub EnterCurrentDate()” “‘EnterCurrentDate Macro” “‘Macro recorded 15/03/2005 by Username” “‘Selection.InsertDateTime DateTimeFormat:=dd-MM-yy”, InsertAsField:=False,_DateLanguage:=wdEnglishAUS, CalendarType:=wdCalendarWestern, _InsertAsFullWidth:=False” “End Sub” Automate your database tasks such as traversing a table by entering the following code: “Sub LoopTableExample” “Dim db As DAO.Database” “Dim rs As DAO.Records
