Need Help Creating a Macro that utilizes a table Posted: 26 Nov 2013 03:04 PM PST I am working to update contracts. I need to be able to allow our sales team to pick what pricing rate card (or table) they want to insert in the contract. I would like to do this using a button for each different price matrix, so they can select and drop in. I know how to record a basic macro, but can't figure out how to easily incorporate a table. Can someone provide direction? I am not a very technical person, so the solution needs to be easy. Thank you. |
word 2007/2010 track changes reviewing pane overwrites text Posted: 26 Nov 2013 02:55 PM PST Apologies that this is repeated. The example images did not appear to upload the first time. An office 2010 document, written on a PC (Windows 7 home premium) with track changes turned on, has been sent to a collegue who uses a Mac. The document has then been returned with another set of changes and comments. The laptop on which the document was written was purchased in Ireland and the editing has been done in Australia. When a comment is clicked parts of the returned document disappear under either: blue grey 'highlights' see example 1, a black block, see example 2; or if the reviewing pane is showing the display of the reviewing pane itself, see example 3. This behaviour is not consistent. One or other or none of the above may occur when clicking on a comment. The layer appearing on top of the document disappears if scrolled off the screen and back, although sometimes it reappears in the same or different form. The issue cannot be resolved by resaving the document with a new name or copying and pasting to a new file. The document has been opened on several PCs in different locations, using Windows 7, Word 2007 and 2010 and the problem appears on them all. Any suggestions as to how this problem might be overcome would be gratefully received Example 1 Example 2 Example 3 |
Word 2010 track changes reviewing pane appears over text Posted: 26 Nov 2013 02:50 PM PST An office 2010 document, written on a PC (Windows 7 home premium) with track changes turned on, has been sent to a collegue who uses a Mac. The document has then been returned with another set of changes and comments. The laptop on which the document was written was purchased in Ireland and the editing has been done in Australia. When a comment is clicked parts of the returned document disappear under either: blue grey 'highlights' see example 1, a black block, see example 2; or if the reviewing pane is showing the display of the reviewing pane itself, see example 3. This behaviour is not consistent. One or other or none of the above may occur when clicking on a comment. The layer appearing on top of the document disappears if scrolled off the screen and back, although sometimes it reappears in the same or different form. The issue cannot be resolved by resaving the document with a new name or copying and pasting to a new file. The document has been opened on several PCs in different locations, using Windows 7, Word 2007 and 2010 and the problem appears on them all. Any suggestions as to how this problem might be overcome would be gratefully received Rod Scoullar. Example 1 Example 2 Example 3 |
Continue footnotes from previous section rather than start of document Posted: 26 Nov 2013 02:39 PM PST Is there any way to restart footnotes after some section breaks so that they continue from the previous section but not from the start of the document? I have a document that has separate chapters and I want to restart the footnotes for each chapter. However, sometimes I also need to include section breaks within chapters and I don't want to restart footnotes after these section breaks. For example I might have 2 chapters: In chapter 1 I have one footnote. Then I have a section break. Then I start chapter 2 which has a section break in the middle. There is one footnote before the section break in chapter 2 and one footnote after. If i restart the footnotes after the first section break and then continue the footnotes after the second section break my footnotes are numbered like so: 1,1,3. What I want is my footnotes to be numbered: 1,1,2. In other words, when I continue the footnotes, I want them to continute from the previous section but not from the start of the whole document. Is there any way to do this? I am open to using VBA. Thanks Josh |
Style Options Word 2010 Posted: 26 Nov 2013 02:19 PM PST In one of our computer labs, it is necessary to have multiple versions of Office installed on each PC. We have 2007, 2010, and 2013. On the 2010 version (Professional Plus) users are unable to access the "Styles" options. Normally, when clicking on the Styles menu and then hovering over the Styles sub-link, multiple options show up. Bold, formal, etc. For some reason when doing this, the only options that can be seen are links for Word 2003 and Word 2010. These links can be chosen as default, but the rest of the links (Formal, Bold, etc) that should be present are not. Anyone know a fix for this? |
Print labels- how do I have different formatting for different lines on a label? Help! Posted: 26 Nov 2013 02:17 PM PST Hello- I'm creating print labels for some charts. I have all the information in an Excel database, and was able to successfully import it into MS Word. However, I'm having trouble with the formatting. I want the formatting to look something like this for every label- DOE, JOHN SWE 09-10 The name at top should be larger font and bold print, and the line below should be smaller font and not in bold. In other words, the top field has a different format than the bottom field. Here is my problem though- when I try to format it in this manner, I can only get it to work correctly on one of the labels- see pic below- DOE, JOHN is the desired formatting in the upper left corner. However, when I use format painter to try to get all the other labels the same way, it just takes the formatting from the top field and applied it to everything else, which results in the second line being bold faced and a larger font, which is not what I want. You can see the results in the pic below. How can I get the formatting on all labels to match the formatting of the DOE, JOHN label? |
BuildingBlockEntries issue reposting, help please.... Posted: 26 Nov 2013 01:43 PM PST Ihello, i am reposting my original question in the hope that a VBA expert will help me... i am quite desperate at it. many thanks! kind regards valeria Dear experts, I am trying to get the pages of my documents numbered via macro (having a small triangle at the bottom far left-hand side of the pages). I have simply recorded a macro and when I am inserting it in my code, when I arrive at the BuildingBlockEntries line, it give me error "the request member of the collection does not exist". My building block template/add-in is enabled in word options, what I am doing wrong? Here is the code: ActiveDocument.AttachedTemplate.BuildingBlockEntries("Triangle 1").Add _ Where:=Selection.Range, RichText:=True 'this is the line giving problems Selection.HeaderFooter.Shapes("AutoShape 2").Select Selection.Font.Color = -587137025 Selection.ShapeRange.Fill.ForeColor.ObjectThemeColor = _ wdThemeColorBackground1 Selection.ShapeRange.Fill.ForeColor.TintAndShade = -0.15 Selection.ShapeRange.Fill.Visible = msoTrue Selection.ShapeRange.Fill.Solid Selection.Font.Name = "Calibri" Selection.Font.Size = 28 Selection.Font.Bold = True what I need is that what I am doing is applicable and triggered by Macro for all documents on a workstation - as I will be printing labels and cannot save them. So every time the operator calls a label and sends the print command, I am copying the same label the desired number of times and then applying the formatting for page numbering and then printing the labels from a single file (I have tried the other way in the previous posts by printing every page as single print command however our printer gets stuck and very slow when I print over 20 labels). So I do not know if it all makes sense and if I was too obscure :-) .... It is 4 hours I am trying to understand the Word VBA language and getting very frustrated by not being able to tell Word that I just need the numbering with the small trinagles!!! the code is what I get from the macro recorder. i should have specified, the labels I am talking about are A4 format so 1 label per page(horizontal layout). It's the kind of labels used for 200 l drums or bigger packaging, and I basically need to number the drums as they are run out with the product... as I said before, I had a solution that worked on paper and for smaller sets of labels but when you need to print out 120 labels or more I know now that that needs to be on 1 file only... hence my copying them and trying to number the pages. |
Word docs Posted: 26 Nov 2013 12:19 PM PST Can someone please help me recover my docs. I used the drag option to put my docs in my flash drive. When I went to open them they appeared as shortcut.Ink. I tried to go to the control panel and restore files, but I must be doing something wrong. Can anyone tell me how to get my files or are they gone? |
Saving Macro Short Cuts Posted: 26 Nov 2013 11:07 AM PST Hi some years ago I managed to create a set of macros in Word 2007 and the short cuts at the top of the page relate to 33 macros that I use for a particular risk assessment document. It works well, but my computer is getting on a bit and I am looking to upgrade. My question is, If I load the latest version of Office onto my new PC, what do I have to do to get these Macros visible and working as they are now? thanks for any help Stuart |
Problem with Numbers Printing Beside/Behind Graphics Posted: 26 Nov 2013 10:05 AM PST I've been encountering a frustrating problem with Word 2010. My clip art and other graphics appear just fine on the screen, however when I print the document, numbers will print beside and sometimes partially obscured behind some of the graphics. Other graphics print normally. The numbers appear to be line numbers, however they show up only when I print, even after disabling line numbers. I have been unable to find any mention of this issue online. Anybody have any insight? |
OFFICE ONLINE IMAGE LIBRARY -- NOWHERE TO BE FOUND... Posted: 26 Nov 2013 09:59 AM PST Yesterday the image library worked -- today not so much. Is this free library still available? I use this library everyday and it will be a HUGE issue if it is no longer available! Can someone please advise? My bookmarked site is now a "how to insert the art" site -- I already know how to do that, I NEED THE ART ITSELF! |
How to change merge field color based on value of that merge field? Posted: 26 Nov 2013 09:48 AM PST Hi, I have a mail merge document. There is a mailmerge field <<year>>. Depending on it's value, we want to print the year in different font colors. For instance if year = 2013, then font color = black, if year = 2014 then font color = green, if year = 2015 then font color = blue. I have reviewed this example: {IF{MERGEFIELD Addr1} = "PO *" {MERGEFIELD Addr1 \* Upper} {MERGEFIELD Addr1 \*Lower \*Caps}} where 'Addr1' is the data field's name. But the switches do not seem to include the font color. I have thought about macro code but am not proficient in VB code and cannot find an example where they are changing the color based on the value of the field. It seems like a simple task, but I have spent 5 hours trying to find something to guide me and now submit my question for your help. Thank you in advance for your assistance. Best Regards, KClench |
Office Word 2010: Main tabs not shown in ribbon Posted: 26 Nov 2013 09:24 AM PST I have had this problem for quite some time and have tried everything suggested thus far. The ribbon shows only the File tab. Although all of the other main tabs are checked in the customization menu, none of them show up in the ribbon. Would appreciate any help from someone familiar with this problem. Thank you. |
strange Characters appearing when I save in web Posted: 26 Nov 2013 07:50 AM PST I'm sending out my message as a web page filtered document but it comes back with these strange characters, usually when spaces are supposed to be there E-Notes  of The Toronto Bruce Trail Club What are those funny A A with something at the top of each? How do I avoid them? Thanks Grant |
I dont know where my Office programs have gone. Posted: 26 Nov 2013 07:47 AM PST My PC is about 2 years old now, I have had Microsoft office 2010 installed and working perfectly since I built my PC, but about a month or two ago it has disappeared (as far as i can tell) from my hard drive. My word documents are still here and i can access them through word pad, but I cant look at any other files such as excel sheets. My OS is Windows 7 64 bit. Any help would be appreciated. |
When will Word citations be fixed? Posted: 26 Nov 2013 07:13 AM PST For a long time Word citations has been crashing for documents with a more than a couple of hundred citations. It is some kind of memory bloating effect. This has been posted for Word 2007 and Word 2013, running on Win 7 all the way to Win 8.1. There are numerous other citations issues but this one prevents updating citations in word, leaving the citations function useless for Word docs with many citations. So far there has been zero feedback on this issue by Microsoft.... |
Image caption dialog won't let me enter a caption (Word, Office 365) Posted: 26 Nov 2013 07:00 AM PST I have an image in a document and I want to give it a caption, But the caption field in the caption dialog will not let me enter anything. In fact it never seems to get the focus, even by clicking in it. I am running Word in Office 365 (2013) on windows 8.1 Any ideas? |
Word Macro Question Posted: 26 Nov 2013 06:49 AM PST Hello, I have one table in Word which needs to be formatted , this involves various steps – I am to automate some but would need help with below ones for Table : First I would explain structure – this may contain various row and Columns but mostly 1 columns would be having description followed by other Columns having amounts, some of the rows are formatted with Border and other just left blank Below are requirements : 1) If one of the rows have BOTTOM BORDER then macro should add 4.5 cm spacing before border (between text and border) – This should only happen if Row has both BORDER and TEXT/Descriptionm 2) Same if I have TOP BORDER then it should add 4.5 cm spacing only if TEXT or Description in whole ROW 3) Also we add one pop up box to define Column width of only FIRST COLUMN – other columns should be 2.3 by default Can someone help me with this. I have some more formatting to be done but if we can start with this that would be great. PP |
Word 2010 Freezes Posted: 26 Nov 2013 06:26 AM PST I'm seeing with files, they essentially freeze and the display changes to a crazy format when I am editing in Word 2010. When I close them down using Task Manager and reopen them, they revert to previous states (i.e. saved changes are gone). It is happening with files from different TRs, so the issue seems to be within the files themselves (perhaps something odd from the scan). The issues do not occur if I work on them in Word 2013 (so far). Note that there are some visual artifacts in the chapters, as well, that are not text, Word objects, etc. – for example, rules that cannot be selected, that do not move with text, etc. |
f7 is tab not spellcheck Posted: 26 Nov 2013 06:08 AM PST Hello, When using Word 365, when I press the F7 key, it produces a tab, it should launch spell check. My keyboard does not have special functions. Please help! |
Section Page Numbers X of Y Posted: 26 Nov 2013 05:03 AM PST Hi, I have a document which is divided into sections. I can number pages starting from each section at page 1.but when setting number of pages it returns all pages in document. not the pages in the section. My question is how do I change so I can have Page X of Y Pages for the section only. appreciate any assistance. |
Unable to send a mail merge document from Word in HTML format. Posted: 26 Nov 2013 04:53 AM PST Hi, I am currently unable to send a mail merge in HTML format and this is required for a project that we are looking to roll out with the next 7-14 days. If I send it as Plain Text or an Attachment, there is no problem with the emails being forwarded to Outlook and sent to the recipients. I have Office 2010 and Windows 7 which is our Corporate standard and we are have DELL help desk assistance. There appeared to be a similar issue to this back in 2011 which was resolved with Hotfix KB980681, although this doesn't appear to be compatible with my current setup. We are just in the process of having Lync rolled out which is part of Office 2013, so I have no idea whether that could be related to this issue in anyway, although it only appears to have happened recently (sometime within the last couple of weeks). Does anyone have any ideas whether there is a known cause for this? I could provide a screenshot of all installed updates if required. Our updates are controlled by 'Service Centre' which might be a DELL program as they have to ensure all software we use is safe and secure. Thanks Lee :) |
Macro to embed images while keeping their correct size Posted: 26 Nov 2013 03:52 AM PST This is a rather obscure one. I have successfully used the following macro to embed inline images in Word 2007 documents, but it has stopped working for Word 2010. Why not simply use the UI to "Save picture in document"? Because Word forgets that the image may have been re-sized. (This is a long-standing "feature".) Can anyone suggest why this macro may no longer work in Word 2010? UPDATE: Forgot to mention the error message that appears on running this: "The link does not exist" Sub FixInlineShapes() Rem This fixes the fact that embedded images are not being resized Dim objInlineShapeA As InlineShape Dim objSelection As Selection Dim rngStory As Word.Range Dim lngJunk As Long Dim Height As Long Dim Width As Long Rem This weird next line ensures that images in headers don't get missed. I found it on the Web and have no idea how or why it works. lngJunk = ActiveDocument.Sections(1).Headers(1).Range.StoryType For Each rngStory In ActiveDocument.StoryRanges Do For Each objInlineShapeA In rngStory.InlineShapes If Not objInlineShapeA.LinkFormat Is Nothing Then Height = objInlineShapeA.Height Width = objInlineShapeA.Width objInlineShapeA.LinkFormat.SavePictureWithDocument = True objInlineShapeA.Height = Height objInlineShapeA.Width = Width End If Next Set rngStory = rngStory.NextStoryRange Loop Until rngStory Is Nothing Next End Sub |
Windows touch screen - printer preferences Posted: 26 Nov 2013 03:28 AM PST How do I find out how much ink is in each of my print colors - I used to be able to find out under printer preferences - advanced, but no longer? |
Microsoft Word 2013 is printing blank pages Posted: 26 Nov 2013 02:34 AM PST Hi all, Can anyone help with this strange problem? I use Microsoft Word 2013 (32 bit version) as part of the Office Home and Student suit (Windows 7 64bit Professional) It's always worked fine in the past but lately, whenever I try to print anything all I get are blank pages. The weird thing is that the paper goes through the printer 'as though' something is printing but every time it is blank. I've tried printing documents that in the past printed fine but the same thing happens - nothing is on the paper. The text setting is on black or automatic and I believe there are no hidden characters. It may be a coincidence but this seems to have happened when I tried to use a letter template, but now even if I type onto a blank document, nothing prints. Has anyone got any ideas what has happened here? I have the latest printer drivers for my Canon ip4500 and as far as I know the printer is fine. It seems to be a Word or Office problem. It's very frustrating. Phil |
Microsoft cross reference type missing Posted: 25 Nov 2013 11:53 PM PST My colleague and I work on the same document, both have identical word versions! However when she opens the cross reference dialogue under reference type, there are more than the standard options available, she also has the option "Graphique" and then subsequently below all the captions that were created via SEQ Graphique \* ARABIC. Myself I do have the captions in the document, but when I would like to enter the cross reference, I dont see the Graphique option as reference type. When its a Table , the second reference type that we use, I see it and I can apply it.... thank you very much for the help in advance, I cannot be more curious what the solution would be! |
Microsoft Office Home and Student 2010 Posted: 25 Nov 2013 10:53 PM PST Hi I have installed MS Office Home and Student 2010 on my desk top computer and all is okay until I opened a new word page and clicked on File and then clicked on Options to customise it. Now as I dont like the way I did it I now cannot remember how it was before I changed it. Can any one email me on what had a tick next to it and what did not have a tick or can it be done an other way. My email address is *** Email address is removed for privacy *** to send all ten sections as there are ten sections in the Word Options box when it comes up. |
Comment box too long Posted: 25 Nov 2013 10:23 PM PST Firstly, please note that the balloon text is set to 9 pt and it is readable. I'm using Word 2010 and typically don't have any problems inserting comments into documents. I was emailed a new document today and when I tried to insert a comment the balloon box stretched to at least 2.5 pages wide. The balloon text is of normal size and is readable, but the box is much too wide. I have no idea what version of Word this document was created on. This problem only occurs with this one document, all others are fine. How do I shrink the comment box back to its normal width? |
Is there a tool to diagnose a DOCX file? Posted: 25 Nov 2013 05:19 PM PST Hello, Bear with me, please. This is a long question. I created a 98 pages manual for a customer in Word 2013. Very standard stuff. No strange fonts or styles, no section break, nothing out of the ordinary. I sent the doc for review, and my customer slapped fifty pages of tables in the middle of it in a landscape section. Now the document gives me some error messages (see below) and does not save with a new name. When it opens, it opens as Document1 (or whatever the number at that point), as if in recovery mode. Since I thought I was very clever, I went back and opened my original document, copied only the tables from the new doc, cleaned all the formatting first, and slapped into my original doc. Only to see it show the same behavior (luckily, I have a back up). So much for clever. So my question is: how do I find what is wrong in these tables and fix it. I don't want to retype the whole thing. I know: without seeing it...but I can't make the document public, as part of my NDA. Here is the message when it opens (I love "unspecified error". It is very helpful). Below this one is what I get when I press ok. (I just realized pictures do not show here. Ah, well...I won't write it again) The document then opens, but starts acting weird. Here is a piece of a table to show how uneven they are. (Please note: I didn't create this THING). So, to wrap it up: I am looking for a way to diag the DOCX that came back from the customer with the table. Short of that, a way to completelly immunize and "de-format", a table so that I can use the contents and don't have to retype it. Tables were written in a Word 10, Win7-64. I run Word 13 Win7-64. I told you it was a long one. Thanks, Delio |
how to cite an article in an online database (using MLA)? Posted: 25 Nov 2013 05:17 PM PST I'm doing a college research paper and I have a few sources from Academic Search Complete, but can't seem to find an appropriate way to cite them within Word. The article I'm trying to cite is from a magazine and my MLA guide from my professor says citations from "Library Database Sources" should be in this format for magazine articles: print citation followed by name of database in italics then "Web." the data of access. example from book: "The Trouble with Immortality: If We Could Live Forever, Would We Really Want to?" Newsweek 5 July 2010, US ed.: 78. Academic Search Complete. Web. 9 Dec. 2010. Please tell if how I can accomplish this with Word's citation system. |
Table Features in Word Posted: 25 Nov 2013 04:39 PM PST I am using Word 365, and I am unable to edit the font color or the background color within a table. I am unable to do this with tables inserted within Word, or copied from Excel. Somehow, a default setting is fixed, even after I select the text and use the drop down selections to choose other colors. Thanks for the help. |
Microsoft Word Copyright Issues Posted: 25 Nov 2013 04:35 PM PST Hello, I have looked over the Licensing for my non-commercial version of Word 2007, and I have a question regarding the legality of using MS Word for writing short stories and publishing them for profit. If I am using MS Word commercial or non-commercial products and write for a living or seek to, do I need to get further permissions from Microsoft to be able to use their product for such an effort to earn money by writing short stories or poetry or essays? According to what I read on the MS website, the fonts themselves may well be copyrighted and could not be used in commercial applications without getting further permissions. But my version of Word is non-commercial anyhow, so what is the legality of me writing as mentioned above using MS Word and trying to earn money from those efforts -- say by publishing on the Kindel or some similar Internet based device? or just publishing essays, poetry, or short stories in a type of printed out book format or Word file for a profit using either the commercial or non-commercial MS Word product? Thanks in advance. |
Get text in multi-line footnotes to align Posted: 25 Nov 2013 04:09 PM PST Hi I work on big reports with lots of footnotes. According to our organisation's style manual the text in footnotes is supposed to stay aligned like this: 1 Smith (2012) said blah blah and John (2010) said blah blah blah. That is, the text in the second line should be directly beneath the text in the first line. In the example, the first 's' in said is supposed to be directly beneath the 'S' in Smith. I've tried using hanging indents but they have to be different for each footnote and have to get updated if the number of footnotes changes (i.e. when the above footnote becomes footnote 11 rather than 1 the text would get pushed across and throw out the indent. Is there any simple way to get consistent indents either with or without the use of a macro? Josh |
How to maintain bulleted/numbered text embedded in a merge document Posted: 25 Nov 2013 03:50 PM PST I have 2 version of a document, the usage of each is governed by what a date is in my merge dataset. What I *want* to do is, instead of having 2 separate documents, I want to create one unified merge document. At the time of the merge operation, the text will switch between the 2 documents based on whether a date in the dataset is older than a given date, or newer (<= vs >=). I know how to construct the document itself, having done so for other situations, but this one has me stumped: the newer document has text that is formatted with the bullet/number tool in Word. (I'm currently using word 2000, but I'm having to migrate to word 2010 in the very near future, and no, 2013/365 is NOT an option - it's what my office is moving to.) The problem is, the numbered text will reside in part of an if/then/else merge argument. When I go to copy/paste the numbered text into the merge code, the numbered list is "broken" - the text is all correct, it's just no longer numbered. I've tried adding the formatting after adding it into the if/then/else statement, but it just won't work. For example, hitting F9 to reveal the merge code would look like: {if{mergefield that_date} =< "10/1/2013" " text from the older non-numbered document here" " 1. paragraph a text 2. paragraph b text 3. paragraph c text"} As soon as I copy/paste: 1. paragraph a text 2. paragraph b text 3. paragraph c text the numbering is wiped out. I imagine the results would be the same if I were to use bullets instead. I probably *can* do it via a table with the paragraph numbers in one column and the text in a 2nd column, but I wanted to try and give The Powers That Be the *exact* formatting from the final version of the new document they gave me. Thoughts? Thanks for your time! |
Office Home&Student 2013 Can not get into any of the program Posted: 25 Nov 2013 10:58 AM PST Can not get into any of the program ie word, excel. power point etc? |
I can't open any of my Office Programs. Sorry, something went wrong and Word was unable to start Posted: 25 Nov 2013 10:38 AM PST I recently bought Office 2013 about a month ago and it installed without a hitch. Then 2-3 days ago it just stopped working. When I click on a saved Word document or try open a new one this message comes up "Sorry, something went wrong and Word was unable to start. (2)". This is really annoying because I really need to use Word as I have lots of work and revision to do for my Exams at the end of this year and I don't have £100 to spend on another Office booklet thing. If you know how to fix this please help out, much appreciated. GrantVolrath |