Pages

Search

Microsoft Word - Macro Enabled Document

Microsoft Word - Macro Enabled Document

Macro Enabled Document

Posted: 10 Jul 2014 01:53 PM PDT

I use Microsoft Word 2010.  I switched a macro enabled form template to a macro enabled form document because the users of the form were not using the template correctly when they were filling in the form so that I could fix the form after the fact.  I had two fields that I had originally created using the create date field which will not work now since some users are not saving the form as a new document so it would have the original date of the form.  Is there a way of creating a macro that will update the two date fields to the current date when the original form is opened but not update if the form when it is saved as a new form?  I have set the goDate macro as the Run Macro on Entry field.  I tried using the following but it did not always work for other users:

Sub goDate()
    With ActiveDocument
        strFile = .Name
    End With
    If strFile = "00789329.DOCM" Then
        ActiveDocument.FormFields("Invoice").Result = Date
        ActiveDocument.FormFields("ExpenseSheetDate").Result = Date
    End If
    If strFile = "Expense Sheet(00789329xB751B).docm" Then
        ActiveDocument.FormFields("Invoice").Result = Date
        ActiveDocument.FormFields("ExpenseSheetDate").Result = Date
    End If
    If strFile = "Expense Sheet(00789329xB751B-1).docm" Then
        ActiveDocument.FormFields("Invoice").Result = Date
        ActiveDocument.FormFields("ExpenseSheetDate").Result = Date
    End If
    If strFile = "Expense Sheet(00789329).DOCM" Then
        ActiveDocument.FormFields("Invoice").Result = Date
        ActiveDocument.FormFields("ExpenseSheetDate").Result = Date
    End If
    If strFile = "Expense Sheet(00789329xB751B-1).docm(Read-Only) - Microsoft Word" Then
        ActiveDocument.FormFields("Invoice").Result = Date
        ActiveDocument.FormFields("ExpenseSheetDate").Result = Date
    End If
    If strFile = "Expense Sheet(00789329xB751B-1).docm(Read-Only)" Then
        ActiveDocument.FormFields("Invoice").Result = Date
        ActiveDocument.FormFields("ExpenseSheetDate").Result = Date
    End If

What am I doing wrong?

Linking Separate Documents Into One File

Posted: 10 Jul 2014 01:05 PM PDT

Hello,

I have document templates into which I have inserted variables (ex. #A = Client's Name).  Most client's I serve require a number of individual documents.  However, the footer including page numbers prohibits me from creating one long document.  What I would like to be able to do is to do one Find & Replace for all of the documents at once. 

Is there a way to combine documents into one document while maintaining pagination, footers, etc.?

The server couldn't complete this action. Error Code: 0x88ffc008

Posted: 10 Jul 2014 12:39 PM PDT

Word says "The server couldn't complete this action. Error Code: 0x88ffc008" when I want to share a document.

  1. It's 2014 -- why do we have 1960's vintage error messages?
  2. WTF does this mean and what can I do about it?

Saved on SkyDrive (or OneDrive) in a machine not in a domain. 

3d Effects grayed out - it is a .docx

Posted: 10 Jul 2014 12:17 PM PDT

Hey all,

I'm really frustrated here.

Last week, I created a simple logo which was just a box with some text in it. This week, I went to do the same exact thing I did last week, and now the "3d effects" button doesn't pop up in the Drawing Tools - Format ribbon like it did before.

What's more, even when I try to force Word to show me 3d Effects in a custom tab, it's grayed out.

The file IS a .docx... and my "save files in this format" is set to .docx. It doesn't matter if I start a new file or open a file I saved-as.

Any idea why this is happening now, when, just last week, it was working fine?

Word Fields, Avoiding Divide by Zero

Posted: 10 Jul 2014 11:50 AM PDT

Hello, 

So I am having an issue with Word Fields.

I want to create a column, c, that divides the number in column a by the number in column b.

However, if b is equal to or less than 0, I want to get 0.

This seems like a simple if statement: { =IF(B1<=0,0,A1/B1) }

Regardless of the value of A, this works fine.  For my example, A will equal 5.

If B equals 1, it will evaluate correctly.  B is not less than or equal to 0, 5/1=5

If B equals -1, it will also evaluate correctly.  B is less than or equal to 0, 0

If B equals 0, it will NOT evaluate correctly.  B is less than or equal to 0, 0, but since the true would have evaluated to 5/0, the field gives up and returns nothing.

Is there a fix?

I could use A1/(B1+verySmallNumber), but I'd rather prefer not to if there is another way.

Thanks,
Christopher

Windows 8.1/Office 2013 when opening office files from mapped drive only aplication is lunched

Posted: 10 Jul 2014 08:22 AM PDT

Hi

Setup

Windows 8.1 surface pro 2, office 2013, Server 2003,

Problem

When I try to open any office files ( .doc, .xls, .ppt) from mapped network folder only correspond application is lunched  but file does not get opened. When i open the same file from the same location but rather than using mapped point i type the unc path everything works fine. Offline files are disabled, network share is on windows 2003 server. If do the same on windows 7 and office 2010 it works fine and if I do this on another laptop with the same setup it works as well. Any ideas ??

Many thanks in advance

Some words in documents created using Word 2007 combined together after viewed and saved in Word 2013.

Posted: 10 Jul 2014 08:18 AM PDT

So the document was initially created in Word 2007 program then it was being viewed, edited and saved in Word 2013. When the edited document was returned to be view in Word 2007 (the one that created it but on different PC), some words appeared to be combined together, for instance, in Word 2007, you typed "My name is John" and then you edited in Word 2013 and everything look just fine before and after saved in Word 2013. When returned to Word 2007, it became: "My name isJohn". 

Can anyone what's wrong here and how can I avoid this issue in the future? 

A mail merge annoyance

Posted: 10 Jul 2014 07:52 AM PDT

I am little tired of this every time I use the mail merge.  After I am finished the merge and begin to work with the documents, I notice that the " Do not check spelling and grammar" box is checked.  Repeatedly, I have to return to the dialogue box to keep unchecking the box.

Is there any solution to this annoyance!!

 

green alignment lines for graphics in word 2013 suddeningly stopped working

Posted: 10 Jul 2014 07:46 AM PDT

The green graphic alignment lines suddenly stopped working in my Word 2013. How can I fix this? Thanks.

Office 2000 will not open

Posted: 10 Jul 2014 07:28 AM PDT

I downloaded the recent Windows Update today and now Office 2000 will not open my documents. It gives me the message "There was a problem sending the command to the program". Is there a solution?  Thank you

How to I add English words to my custom dictionary?

Posted: 10 Jul 2014 07:26 AM PDT

I am having trouble adding english words to my custom dictionary.

My dictionary is set to custom with the language as english, as when I change it to 'none', spellcheck doesn't pick up on any mistakes.

It will allow me to add some words such as names or scientific terms, but when I try and add an english spelling ( recognising instead of recognizing).

Can anyone help me?!

I'm using microsoft 2008 on a mac.

How to create a colored shadow for a picture in Word 2010?

Posted: 10 Jul 2014 07:04 AM PDT

I'm trying to edit a preexisting word document and cannot figure out how to recreate the show effect that is on the document's pictures. Please see below:

How can a recreate this blue "box shadow" on a new image that I put in the document? If I try to replace the picture that is already in the document like the one above, it completely removes the shadow and my new image is pasted without any of the pre-existing effects.

Any help would be truly appreciated!

Microsoft Equation 3.0 editor suddenly not working

Posted: 10 Jul 2014 06:41 AM PDT

I my windows 8, I was working in a word document, and wanted to use Microsoft  equation 3.0 editor as I used to do it with my new laptop for nearly a year, but to day suddenly it is not responding. When I go to : insert, object , in object type box  there is a message says " Insert a new Microsoft equation 3.0 object in your computer". in fact  I noticed that this message is repeated for all items in the object type box . Can any one please help me?

Creating a conditional question on within a fillable form word 2010

Posted: 10 Jul 2014 06:05 AM PDT

I have a drop down menu question with 5 options. If a user selects one of 2 of the 5 options I want a subquestion to appear 

Numbering the text boxes on a sidebar

Posted: 10 Jul 2014 02:50 AM PDT

I inserted a sidebar with the chapter number on the margins of a document, as part of the header, so it repeats on the corresponding pages. For example, Chapter 2 has a corresponding sidebar "Chapter 2" on pages xx-yyy.

As I add new chapters and re-adjust the titles in the text boxes in the sidebar, the chapter numbers in the text boxes do not follow the ordering of the chapters but rather the ordering of the text boxes themselves. For example, where there is Chapter 3 in the title, the sidebar says "Chapter 8" (see the screenshot). I tried to delete it and add a new text box, but then it says "Chapter 11". As this is obviously a matter of ordering text boxes, how can I order them? Here I do not mean dragging them from one page to another but rather changing the way they appear in a document.

Thanks,

Lana

Track changes and change user name

Posted: 10 Jul 2014 01:14 AM PDT

Hi everyone

I received a document with track changes on. As expected, the changes were red. When I added my text, they were blue (so far, so good). Unfortunately, what seems to have happened is the colours have reversed so now I'm the first author (my changes are in red) and the original editor's tracks are in blue.

Now my text is purple (as a third editor). I have added other names in the "change user name" in the track changes box to try and fix it. That's made things worse. There are now five reviewers.

Question: Can the reviewers added through the "change user name" be deleted so I am back to square one? No additional names. 

Any help appreciated with this.  

Changing the display and help language of Microsoft Office 2010

Posted: 10 Jul 2014 12:53 AM PDT

Hello there

I have recently purchased a new laptop from Taiwan and I am currently having difficulties trying to change the display and help language of the pre-installed Microsoft Office programs (such as Word, Excel etc.)

The language of the Microsoft Office programs were pre-installed with traditional Chinese, and I would like to change it to English UK. I've done quite a lot of research on how to change it but none of those solved my problem. The picture below shows the language options within tools in Microsoft Word:

I've set English UK as my primary editing language (in the first line of the editing tab), but in the tab below (the display and help languages) the only 2 options were "match Microsoft Windows <default>" and "Chinese (Traditional)". I have also changed the language and location settings of my laptop to English.

Much Thanks

Word, excel have stopped working after latest update

Posted: 10 Jul 2014 12:39 AM PDT

so added to outlook having gave up 2 weeks ago and there seems to be no one that can fix the problem, today after the system had once again updated itself I now get this message

I also received this message for word and pressed the yes button and now word has disappeared completely from my system.

I am extremely hacked off with these products!!!!!!!

Can anyone help in a clear and understandable English, I am not an expert on MS products nor on the workings of programming I am a simple end user.

change language pasted text

Posted: 10 Jul 2014 12:36 AM PDT

How do i prevent word from dealing pasted text as english when it is Norwegian? Example: I copy text in safari or firefox and paste that text into word. The hole paragraph are then treated as english spellchecking. Looks like word gets some kind of wrong info from the browser..How do I either paste it as Norwegian or make word discard that meta info. The word-document is set in norwegian but that single pasted paragraph get changed to English. Thank for any help.

Problem with pictures pasted from powerpoint to word

Posted: 09 Jul 2014 11:52 PM PDT

I have faced a problem with Block Diagrams that I created in Powerpoint and pasted in Word. I pasted the diagrams using default paste(using destination theme). After pasting, the text in the textbox of one diagram combines with the text in text box of another diagram. I am at a loss to understand how this is happening. 

Please let me know why this happens.

Thanks

Anuradha

Word 2010 numbering pages

Posted: 09 Jul 2014 11:34 PM PDT

I have been been trying to add page numbers to my book 180 pages, I am not putting the numbers on the first page. I follow the directions to the letter and all it does is add number 1 to the first page and that is that. I am trying to add themto the center footer, that's all just the numbers. I am ashamed to say I have been working on this for 4 hours. I miss my Word 2000..

Link Textbox control

Posted: 09 Jul 2014 11:20 PM PDT

Hi,

I inserted a textbox, after which I'd copied it and "paste special" => "Paste link" so that when I update the former, the latter will be automatically updated.

But the strange thing is, not only do (1) I have to manually right click, update link, (2) after I've saved and opened it, the objects disappeared (when i right click, there is no "Update link"  option.

What have I done wrong?

Thanks in advance!

Word 2013 COM automation fails to open file when offline

Posted: 09 Jul 2014 11:16 PM PDT

I'm getting a weird error the I'm guessing may be related to OneDrive integration in Word 2013.

I've got a Python script that uses COM Automation to get Word to open a .DOC/.DOCX file (the script should then paste something into the very first line, save the document, and close it).  When I'm online everything works great.  While using Word 2010 everything worked great, online and offline.  

When I'm on the bus (and, therefore, offline - there's no WiFi/Clearwire/etc for my laptop) the script fails, and it fails specifically at the  line where I try to do the following:

wordapp.Documents.Open("path_To_File\file.doc");

The directory that contains the file is in OneDrive; it is marked as being "Available Offline".  

My guess is that when Word 2013 is not on a network it's having trouble with the OneDrive integration.  

I'd love any advice on either fixing this or what to look for next to better diagnose this problem.

MS word 2013: Paste is exrcuciatingly SLOW (8 seconds)

Posted: 09 Jul 2014 10:02 PM PDT

Paste is very slow in MS words. It can take 8-10 seconds.

I usually copy and paste from a website into MS words document. It could be any amount of text from a few words to the entire web page. Paste is very slow in MS words. It can take 8-10 seconds. To bypass the delay, I just paste into a notepad and then copy paste from notepad into word document.  It has been like this for MANY YEARS for me with MS word.  If I paste into NOTEPAD, it goes band, instant. I am still using the same delay-bypass for many years.

Note: When I tried to paste the same text off the webpage in a new email in Windows Live Mail, it took whopping 30 seconds. Obviously the process of converting original text from website to text suitable for MS products is faulty.

Today I got sick of it and tried to do something about it. Guess what, there is nothing I can do to fix it.

It is MS windows 8.1, MS IE explorer, MS website, MS office, MS words 2013, MS clipboard and MS productivity suite of products which take 8 sec to copy paste from MS website contents into MS words. 

MS, please fix this bugs which wastes my time.

Problems printing multiple pages in Word 2013

Posted: 09 Jul 2014 07:35 PM PDT

When I request printing multiple pages in Word 2013 I only get one page printed each time.  Excel 2013 prints multiple pages properly.  Anyone have a fix?

Can't open my Microsoft Office programs.

Posted: 09 Jul 2014 05:43 PM PDT

I can't open Word 2013 and open any documents I wrote using Word 2013?

Word Page Breaks

Posted: 09 Jul 2014 05:13 PM PDT

I have a document in which there is a organizational chart created with text boxes.  I need to insert a page break after the boxes.  How?

Just Installed Word 1013 and it will not open documents

Posted: 09 Jul 2014 04:51 PM PDT

I have been using Word Starter 2010 on my laptop for a while now. Today I decided to purchase and download Office 365. The Powerpoint and Excel seem to be working fine. I tried to open Word 2013 and I see the options (blank document, flyer, etc). When I click on blank document, I get an error message saying there was a problem and it closes the window. So, I cannot access Word at all and I cannot access my "old" files in Word Starter (I can view them in Word Pad) but that's about it.

Using old MSWord Webdesign program-- but installed Windows 7

Posted: 09 Jul 2014 04:44 PM PDT

I have used MSWord Web program for ten years and it has served me well for my limited knowledge. I just update it every month with new pictures and data and run it in Compatibility mode and it works fine. Although some readers can't see the pictures.

Today I uploaded to the site and it all turned into Chinese.. YIKES what is going on? I have checked, rechecked and check again and can't find anything I am doing wrong. I have upgraded from XP to Windows 7 but I have used the program for three months and it worked fine.

 PLEASE help.. this is an important website for a non profit.

Problem with the Word document buttons on the Windows 7 Taskbar

Posted: 09 Jul 2014 04:05 PM PDT

A major repeating headache when working with Word is the following problem, which has to do with the Windows UI but for me occurs when working with Word. So I apologize if this is the wrong section for asking this question.

When I have several Word documents opened (and many other windows from several applications), the Word documents are displayed as separate buttons on the Windows Taskbar (which in my case is placed on the left side of the desktop). Now I have an auto-start macro installed in Word which displays the whole file-path in the Word title-bar instead of only the file-name, which for me is very important to distinguish documents which may have the same file-name but are in different directories.

This makes it impossible to distinguish which Word document belongs to which taskbar button, because the taskbar button displays the Word title-bar content (which in my case is the whole file-path), so every Word document taskbar button looks the same, and initially I always have to try and click each Word document taskbar button. This of course is cumbersome and time-consuming and not an efficient way to work.

But even when I would uninstall the before-mentioned Word macro it is not easy to distinguish the Word documents in the taskbar as their names may start with similar words, although the taskbar has a width of 100 pixels.

An additional problem in this context is: The Windows 7 taskbar has a very poor (almost none) visual contrast between the taskbar button which belongs to the currently focused window and the other taskbar buttons. Also, when I hover the mouse pointer over one of the Word document taskbar buttons, the text in the document names  popup also has a very poor visual contrast with the popup background (it's almost the same color). However I don't want to use a "High contrast" Windows theme, as I am not visually impaired.

Is there a GOOD solution for this problem? Is it possible to customize the Windows 7 taskbar to make it look like I need? This would be:

  • Customize the color contrast between the current and the other taskbar buttons
  • Customize the color contrast in the taskbar documents popup
  • Customize the taskbar to show only the document file-name, not the whole path
  • Maybe a smaller Word icon in the taskbar buttons with wrapped text inside the taskbar button, to show as much as possible to identify the document.

How to get "y", in Page x of y numbering, to ignore certain pages in it's total?

Posted: 09 Jul 2014 04:01 PM PDT

Hi there,

I have a document where the first 2 pages do not need to be included in the page numbering, but I need to page numbering for page three and beyond to have "page x of y" page numbering format. My issue is that, while I can get "x" to start at 1 on page three, I cannot get the "y" part to stop listing the first two pages of the document in it's total count. How do I get "y" to start at 1 from the third page?