Retaining important formatting when importing Word documents In. Copy. Secrets. Chad Chelius. November 2. 3, 2. ImportExport, Text and Tables. Comments. As Ive written in the past, Word is often an integral part of any In. Copy workflow. In many situations, content is authored in Microsoft Word due to its widespread availability as an application on most computers. Editorial staff often keep content in the Word format when working with authors because its easy to go back and forth with changes until the final content has been completed. Once the content has been finalized, the designer can flow that Word document into In. Design or an editor can flow the content into an In. Copy file in preparation for layout. Although the process of bringing a Word document into an In. Design or In. Copy file may seem like a simple process, retaining the desired formatting of that Word document can present some unique challenges. Notice that I said desired formatting. The word ampersand is a corruption of the phrase and per se and, meaning and by itself and represented by the symbol. Traditionally, when reciting the. I say this because authors are known for applying their own formatting to documents to enhance the visual appearance of the file while theyre writing. Often making headlines bigger or changing their color to make it easier to view and read. This is much more easily accomplished by using styles in Word but thats an entirely different blog post. When you bring Word content into In. Define analogy inference that if two or more things agree with one another in some respects they will probably agree in analogy in a sentence. This topic explains the concepts that are related to retail peripherals. Overview. The following list describes the Microsoft PE executable format, with the base of the image header at the top. The section from the MSDOS 2. Compatible. Design or In. Copy the goal is to remove the undesirable formatting but retain the formatting you wish to keep such as bold and italic styling. Preserving Formatting. Many users will select all of the text in a Word document, copy the text, then paste it into In. Design or In. Copy. In essence, this strips all of the formatting from the text including any formatting you wish to keep. This can be detrimental because work has been lost and will need to be performed by someone a second time. Instead of copy and paste, In. Design provides some options for retaining the formatting of text when you choose File Place. In the Place dialog box, select the Word document that you want to place, then enable the Show Import Options checkbox and click Open. This will display the Microsoft Word Import Options dialog box. Well focus on the Formatting section located at the bottom of the dialog box. This section offers you two main choices for dealing with text imported from Microsoft Word. Remove Styles and Formatting from Text and Tables This will strip out all formatting from the Word document and use the current style in the In. Design or In. Copy document. Preserve Styles and Formatting from Text and Tables This will retain any formatting applied in the Word document and also gives you the option to import any Word styles or map them to existing In. Design or In. Copy styles. Option 1 is tempting but remember, this will remove all formatting including bold, italics, and anything else you actually want to retain. Therefore, more often than not, I take advantage of option 2 in order to retain all of the formatting in the document. Once placed in the In. Design or In. Copy document, all formatting is retained. Cleaning Up the Formatting. Now that you have the Word text in the In. Design or In. Copy document, you need to keep the formatting you want and get rid of the formatting you dont want. To do this, I create a character style for all of the formatting options that I want to retain. Usually this consists of bold, italic, and bold italic formatting although depending on the type of content that youre working with, you may want to create more. When creating the Character styles, only define the properties necessary within the style. For example, when you create your Italic Character style, only define Italic as part of the style. No need to define the font, size or other formatting unless it is very unique formatting. In order to retain the formatting that you want to keep, open the FindChange dialog box by choosing Edit FindChange. Leave the Find what and Change to fields empty, but click on the More Options button to display the Find and Change format sections of the dialog box. Click on the Specify Attributes to Find button and click on the Basic Character Formats section on the left side of the dialog box. Now choose Italic from the Font Style drop down menu and click OK. Now in the Change Formatting section, click on the Specify Attributes to Change button and choose the Italic character style from the Character Style drop down menu. Click the Change All button and youll be notified how many changes have been made. Note that you have options to make this change in all open documents, the current document, the current story, and to the end of the story. Repeat this process for the other styling that you want to retain. Apply Paragraph Styles. Remember, character styles have more power than paragraph styles. So with your character styles applied to the text formatting that you want to retain, you are free to apply the appropriate paragraph styles, and clear any formatting that you wish to remove. Looking at the figures below, you can see the original Word document that was used as well as the final In. Copy file that has been cleaned up using the described method in this article. Weve highlighted the italicized text to make it easier to see. Excel Stock Quotes Free Excel Stock Quote Tracker Macro Workbook Download Chandoo. Posted on June 2nd, 2. Learn Excel, VBA Macros 2. This is a guest post by Daniel Ferry of Excelhero. Have you ever wanted to fetch live stock quotes from excel In this post we will learn about how to get stock quotes for specified symbols using macros. One method that has worked well for my clients can be implemented with just a few lines of VBA code. I call it the Active. Range. An Active. Range is an area on a worksheet that you define by simply entering the range address in a configuration sheet. Once enabled, that range becomes live in the sense that if you add or change a stock symbol in the first column of the range, the range will automatically and almost instantly update. You can specify any of 8. Active. Range. This includes things such as Last Trade Price, EBITDA, Ask, Bid, PE Ratio, etc. Whenever you add or change one of these attributes in the first row of the Active. Range, the range will automatically update as well. Tonight Alive What Are You Scared Of. Sound interesting, usefulIn this post, you can learn how to use excel macros to fetch live stock quotes from Yahoo Finance website. It is also going to be a crash course in VBA for the express purpose of learning how the Active. Range method works so that you can use it yourself. Download Excel Stock Quotes Macro Click here to download the excel stock quotes macro workbook. It will be much easier to follow this tutorial if you refer to the workbook. Background Understanding The Stock Quotes Problem The stock information for the Active. Range will come from Yahoo Finance. A number of years ago, Yahoo created a useful interface to their stock data that allows anyone at anytime to enter a URL into a web browser and receive a CSV file containing current data on the stocks specified in the URL. Thats neat and simple. But it gets a little more complicated when you get down to specifying which attributes you want to retrieve information here. Remember there are 8. Under the Yahoo system, each attribute has a short string Tag Code. All we need to do is to concatenate the string codes for each attribute we want and add the resulting string to the URL. We then need to figure out what to do with the CSV file that comes back. Our VBA will take care of that and manage the Active. Range. Excel includes the Query. Table as one of its core objects, and it is fully addressable from VBA. We will utilize it to retrieve the data we want and to write those data to the Active. Range. Before we start the coding we need to include two support sheets for the Active. Range. The first is called YFAttribs, and as the name implies is a list of the 8. Yahoo Finance along with their Yahoo Finance Tag Codes. The second sheet is called, ar. Configxxxx where xxxx is the name of our sheet where the Active. Range will reside. It contains some configurable information about the Active. Range which our VBA will use. All of the VBA code for this project will reside inside of the worksheet module for the sheet where we want our Active. Range to be. For this tutorial, I called the sheet, DEMO. Writing the Macros to Fetch Stock Quotes Press ALT F1. VBE. Double click on the DEMO sheet in the left pane. We will enter out code on the right. To begin with, enter these lines Option Explicit. Private rn. ARDest As Range. Private rn. ARTable As Range. Private st. ARConfig. Sheet. Name As String. Always start a module with Option Explicit. It forces you to define your variable types, and will save you untold grief at debugging time. In VBA each variable can be one of a number of variable types, such as a Long or a String or a Double or a Range, etc. For right now, dont worry too much about this just follow along. Sidebar on Variable Naming Conventions. Variable names must begin with a letter. Everyone and their brother seems to have a different method for naming variables. I like to prefix mine with context. The first couple of letters are in lower case and represent the type of the variable. This allows me to look at the variable anywhere its used and immediately know its type. In this project Ive also prefaced the variables with AR so that I know the variable is related to the Active. Range implementation. In larger projects this would be useful. After the underscore, I include a description of what the variable is used for. Thats my method. In the above code we have defined three variables and their types. Since these are defined at the top of a worksheet module, they will be available to each procedure that we define in this module. This is known as scope. In VBA, variables can have scope restricted to a procedure, to a module as we have done above, or they can be global in scope and hence available to the entire program, regardless of module. Again we are putting all of the code for this project in the code module of the DEMO worksheet. Every worksheet has a code module. Code modules can also be added to a workbook that are not associated with any worksheet. User. Forms can be added and they have code modules as well. Finally, a special type of code module, called a class module, can also be added. Any global variables would be available to procedures in all of these. However, it is good practice to always limit the scope of your variables to the level where you need them. In that vein, notice that the three variables above are defined with the word Private. This specifically restricts their scope to this module. Every worksheet module has the built in capability of firing off a bit of code in response to a change in any of the sheets cell values. This is called the WorksheetChange event. If we select Worksheet from the combo box at the top and Change in the other combo box, the VBE will kindly define for us a new procedure in this module. It will look like this Private Sub WorksheetChangeBy. Val Target As RangeEnd Sub. Notice that by default this procedure is defined as Private. This is good and as a result the procedure will not show up as a macro. Notice the word Target near the end of the first line. This represents the range that has been changed. Place code between these two lines so that the entire procedure now looks like this The Heart of our Excel Stock Quotes Code WorksheetChange. Private Sub WorksheetChangeBy. Val Target As RangeActivate. Range. If Worksheetsst. ARConfig. Sheet. Name. Then. If IntersectTarget, rn. ARDest Is Nothing Then Exit Sub. If Target. Column lt rn. ARDest. Column And Target. Row lt rn. ARDest. Row Then. Post. Process. Active. Range. Exit Sub. End If. Active. Range. Response. End If. End Sub. That may look like a handful but its really rather simple. Lets step through it. The first line is Activate. Range. This is the name of another sub procedure that will be defined in a moment. This line just directs the program to run that sub, which provides values to the three variables we defined at the top. Again, since those variables were defined at the top of the module, their values will be available to all procedures in the module. The Activate. Range procedure gives them values. Next we see this odd looking fellow If IntersectTarget, rn. ARDest Is Nothing Then Exit Sub. All this does is check to see if the Target the cell that was changed on the worksheet is part of our Active. Range. If it is the procedure continues. If its not, the procedure is exited.