[ Pobierz całość w formacie PDF ]
.Value) > 100000 Thencell.NumberFormat = "##"",""##"",""###"End IfNext cellExit SubWith this code, if the user selects a chart and runs the macro, the run-time error is ignored,the program moves on to the For Each block, and nothing happens because nothing canhappen.If the user selects a range containing one or more error values, the program skipsover those cells that it can t format and formats the ones it can.In all cases, neither error mes-sage nor message box appears, and all is well.This solution is ideal for this particular macro.Of course, when you use On Error Resume Next, you re disabling VBA s run-time checkingaltogether.You should do this only when you re sure you ve thought of everything that couldpossibly go awry and the best way to arrive at that serene certainty is to test, test again, andthen test some more.879Part 10: Automating ExcelChapter 33 Part 11AppendixesA Installing Microsoft Excel 883B Using Speech and HandwritingRecognition 889C Keyboard Shortcuts 903D Function Reference 921881 Part 11: AppendixesAppendix AInstalling Microsoft ExcelSystem Requirements.883 Installing Additional Components.885Installing Office.884 Repairing Your Office Installation.887Uninstalling Office.885With every new version of Microsoft Office, the installation process gets easier for MicrosoftExcel and all of the Office programs.It might not seem that way, however, because every newversion usually takes longer to install and eats up more hard disk space.For most of thisappendix, we ll assume that you purchased Excel as part of a Microsoft Office 2003 package,which is how most of us get Excel these days.Caution You should exercise caution and a bit of healthy pessimism before starting theinstallation of any new software program.You never know what might happen.To be safe,back up important data files before proceeding.System RequirementsThere are too many different configurations of Office to provide system requirements for each.Instead, we ll list general requirements.For specifics about your Office package and operatingsystem requirements, see the documentation provided in the Office 2003 software box.Note Sometimes it s more helpful to tell you what you can t use.None of the new Office2003 suites or their component standalone applications will run on the Microsoft Windows3.x, Microsoft Windows NT 3.5x, Microsoft Windows 95, Windows 98, Microsoft WindowsMillennium Edition (Me), or Windows NT 4.0 Workstation operating systems.If your com-puter is currently running one of these, you must upgrade the operating system beforeinstalling Office 2003 or its standalone applications.To install Office 2003, your computer must have the following:Ï% Microsoft Windows XP or Microsoft Windows 2000 with Service Pack 3, or any latereditions or Service Pack upgrades for these systems.Note The Office Setup program also installs the latest version of Microsoft InternetExplorer.If you prefer to use an earlier version of Internet Explorer, you can turn off thedefault installation using a customized Setup.Office requires Internet Explorer 5.01 or 5.5with Service Pack 2.Any later version of Internet Explorer will also work correctly.883 Part 11: AppendixesMicrosoft Office Excel 2003 Inside OutÏ% A Pentium 133 MHz processor.A Pentium III 200 MHz processor is recommended.Speech recognition features require a faster processor, as we discuss later in this appendix.Ï% The memory requirements specified for your operating system, plus 8 MB per applicationrunning simultaneously.Speech recognition features also require more memory.Ï% Varying hard disk space, depending on your Office configuration and operating sys-tem.For example, space requirements start at 245 MB for Office 2003.Check yourMicrosoft Office package for more information.Ï% An additional 50 MB of hard disk space for each language version of the user interfaceyou install.You should install the same language version of Office as the operatingsystem you have installed.Ï% 115 MB on the operating system drive for the Office system files, if you install Office ona different drive than the one where your operating system files reside.Ï% An additional 100 MB of hard disk space for use by the Windows swap file.Ï% A CD-ROM drive.Ï% Super VGA (800 × 600) with 256 colors or greater monitor.Ï% A mouse or other pointing device.Additional Requirements and RecommendationsThe following are requirements and recommendations for specific features:Ï% Modem/Internet access.(Required for Web features and sending/routing features.)Minimum 9600 baud modem 14,400 baud is recommended.Ï% E-mail features.Microsoft Exchange, Internet SMTP/POP3, IMAP4, or other MAPI-compliant messaging software.Ï% Multimedia.(Required for sounds and other multimedia effects.) An acceleratedvideo card is recommended.Ï% Speech recognition.For all operating systems, the recommended hardware require-ments increase to a Pentium 400 MHz (or higher) processor and a minimum of 128 MBof RAM.Any microphone compatible with your computer s sound system is accept-able, but the recommended microphone is a high-quality, close-talk type, preferably aheadset on which the microphone element can be located within four inches of thespeaker s mouth.A USB microphone, with which a sound card is not required, ishighly recommended.Ï% Handwriting.A graphics tablet is recommended, but not required.Installing OfficeTo start the installation process, do the following:1 Exit all programs that are running on your computer.You must be logged on withadministrator privileges.2 Insert the first CD and follow the instructions on the screen.884Appendix A Part 11: AppendixesInstalling Microsoft ExcelNote If the autorun program fails to start after inserting the CD (it might take aminute), use Windows Explorer to navigate to the CD and double-click the Setup icon.3 Before the installation can proceed, you are prompted to enter a Product Key.Look forthis key on the CD case, enter it in the space provided, and click Next.4 Choose the type of installation you want.Use Typical Install (recommended) unlessyou want to include or exclude particular programs or features.5 Follow the remaining instructions in the Microsoft Office Setup program.Uninstalling OfficeTo remove Office from your computer, do the following:1 On the Windows Start menu, choose Control Panel.2 Click Add or Remove Programs.3 Click Change Or Remove Programs, then click Microsoft Office (or Microsoft Excel).4 Click Remove, and follow the instructions on the screen.Installing Additional ComponentsMost Office features are installed with the program.All others should be available as install-on-demand (also known as install on first use ), meaning that when you choose the com-mand for one of these features, you see a dialog box telling you that the feature is not installedand asking whether you want to install it.You ll need to put the CD in your CD-ROM driveto do so.Note Before running Setup, check to see whether the feature you want is available as anadd-in.In Excel, choose Tools, Add-Ins, and check the list of add-ins available
[ Pobierz całość w formacie PDF ]