Posts Tagged ‘HTML’

Experimenting with Colors Figure 30-3 shows a workbook that I created that deals with colors. If you’re at all confused about how the RGB color model works, spending some time with this color demo workbook will probably make it all very clear. Figure 30-3: This workbook demonstrates how red, green, and blue colors combine. CD-ROM  […]

Text File Manipulation Examples This section contains a number of examples that demonstrate various techniques that manipulate text files. Importing data in a text file The following example reads a text file and then places each line of data in a single cell (beginning with the active cell): Sub ImportData() Open “c:datatextfile.txt” For Input As […]

Chapter 27: Manipulating Files with VBA  Download CD Content Overview In This Chapter In this chapter, I describe how to use Visual Basic for Applications (VBA) to perform common (and not so common) file operations and work directly with text files. A basic overview of VBA text file manipulation features Performing common file operations Various […]

Common VBA Charting Techniques In this section, I describe how to use VBA to perform some common tasks that involve charts. Creating an embedded chart In Excel 2007, a ChartObject is a special type of Shape object. Therefore, it’s a member of the Shapes collection. To create a new chart, use the AddChart method of […]

Internet Features Excel includes a number of features that relate to the Internet. For example, you can save a worksheet or an entire workbook in HyperText Markup Language (HTML) format, accessible in a Web browser. In addition, you can insert clickable hyperlinks (including e-mail addresses) directly in cells. Caution  In previous versions, HTML was a […]

Return to Index Return to Search Index To search for words in the titles of HTML files Click the Search tab, type the word or phrase you want to find, and then select the Search titles only check box. Click List Topics, select the topic you want, and then click Display. Note If you use […]

Return to Index SpeedBible by johnhurt.com How to Use The Search Engine   Searching for help topics To find information with advanced full-text search Searching for words or phrases using wildcard expressions Using nested expressions when searching Using the AND, OR, NOT, and NEAR operators To find words similar to your search term To search […]

The Weymouth New Testament SpeedBible is free for you to download.

Return to Index SpeedBible by johnhurt.com How to Use The Search Engine   Searching for help topics To find information with advanced full-text search Searching for words or phrases using wildcard expressions Using nested expressions when searching Using the AND, OR, NOT, and NEAR operators To find words similar to your search term To search […]

Return to Index Return to Search Index To search for words in the titles of HTML files Click the Search tab, type the word or phrase you want to find, and then select the Search titles only check box. Click List Topics, select the topic you want, and then click Display. Note If you use […]

The Vietnamese SpeedBible is free for you to download.

Return to Index Return to Search Index To search for words in the titles of HTML files Click the Search tab, type the word or phrase you want to find, and then select the Search titles only check box. Click List Topics, select the topic you want, and then click Display. Note If you use […]

Categories