Читать книгу Excel Macros For Dummies онлайн

8 страница из 60

9 Chapter 10FIGURE 10-1: Show legacy wizards in the Ribbon.FIGURE 10-2: Choose the source database that contains the data you want importe...FIGURE 10-3: Select the Access object you want to import.FIGURE 10-4: Choosing how and where to view your Access data.FIGURE 10-5: Data imported from Access.FIGURE 10-6: As long as a connection to your database is available, you can upd...FIGURE 10-7: Select the SQL command type and enter your SQL statement.FIGURE 10-8: Designate a cell that will trap the criteria selection.FIGURE 10-9: You now have an easy-to-use mechanism to pull external data for a ...FIGURE 10-10: Select the latest version of the Microsoft ActiveX Data Objects L...

10 Chapter 11FIGURE 11-1: A single apostrophe in front of any line turns that line into a co...FIGURE 11-2: The Edit toolbar allows you to select entire blocks of code, and t...FIGURE 11-3: Holding down the Ctrl key while dragging code creates a copy of th...FIGURE 11-4: Pressing Shift+F2 with your cursor on a function or variable name ...FIGURE 11-5: Use the Procedure View button to limit scrolling to just the activ...FIGURE 11-6: Press F8 key to step through each line of your macro at your own p...FIGURE 11-7: You can click and drag the yellow arrow while stepping through you...FIGURE 11-8: A breakpoint is marked by a dot in the left margin along with shad...FIGURE 11-9: Showing the beginning and ending characters in a variable tooltip.FIGURE 11-10: Leaving a line of code unfinished, even for a second, results in ...FIGURE 11-11: Uncheck the Auto Syntax Check option to prevent warning messages ...