Pages

Search

Microsoft Word - Creating a macro from pre-existing text

Microsoft Word - Creating a macro from pre-existing text

Creating a macro from pre-existing text

Posted: 16 Nov 2012 10:26 AM PST

I have virtually no experience with creating macros or VBA, so any answers need to be in plain English.
I have a lot of text I use regularly, that I've been copying and pasting into new documents. It would be more efficient if I could make macros of that material.
I've figured out the basics of how to record a macro. What I want to do is to make a new macro from existing text in another document, BUT I don't want the macro, when it runs, to go to that document, copy the text and paste it into the new document. That document may not exist or may have been changed. I want the text I see in another document to actually be the macro, as if I typed it in after hitting "record macro."
1) Is there a simple way to do this?
2) Going one step further, can a macro be written that work like this:
       - open document with desired text
       - type command for magic macro
       -  [macro developer opens, Prompt appears: asks for name and keystroke of new macro, then starts recording]
       - highlight desired text
       - hit stop recording
       - [actual text would be copied into new macro, with proper commands. Prompt would appear to continue adding additional text or save]
       - either select more text or save
3) Would this same technique work if text included other things, such as table,  image, or text box?
Thanks!

         

Is there any way to help the "grammarians" at MicroSoft?

Posted: 16 Nov 2012 10:02 AM PST

Far more than half of the "errors" Word's grammar checker (Office 2010) highlights on my documents are grammatically correct.  My sentence structures are often quite complex, but there are so many flaws in even simple facets of this grammar-correction program that it would be impossible to characterize or describe them.   If anybody at MicroSoft cares that their product is atrociously defective, I would be pleased to forward incorrect "error" signals as they occur or collect them and forward them in batches.   The problem is, there seems to be no way to contact MicroSoft without paying them to do them a favor, which I decline to do.

Mismatched numbering between captions for figures and their hyperlinks.

Posted: 16 Nov 2012 08:58 AM PST

I have a Word 2010 document with graphics that I have cross referenced in other parts of the document.

I selected the figure number and then dragged the caption to a new area. Then I chose the Create Hyperlink option. The hyperlink was inserted in the new location but does not have the same figure number as the number on the caption.

What do I need to do to have the correct figure number appear in the hyperlink?

Thanks.

Elizabeth

Vary Sentence Lengths Macro

Posted: 16 Nov 2012 08:11 AM PST

16 November 2012

To whom it may concern:

I am writing a long book and I am trying vary my sentence lengths. I need a macro that will go through an entire document counting the number of words in a sentence and embedding the word count after each sentence.  

For example:

Jack and Jill went up the hill. (7) Jack fell down and broke his crown. (7) And Jill came tumbling after. (5)

VBA for the 2007 Microsoft Office System seems to have a macro for this in listing 7.9, but I have not yet tried it. Had be very interested to know if someone else has a solution for this problem.

Any assistance would be greatly appreciated.

 

Cordially,

Scipio

How can I remove a watermark that was formatted earlier?

Posted: 16 Nov 2012 07:49 AM PST

I enterd a watermark in a document and want to remove it. I selected "No Watermark" and Word removed it only from the first page. How can I remove it from all pages?

How do I register my retail Office 2010?

Posted: 15 Nov 2012 05:14 PM PST

 I purchased a retail copy of Office 2010. How do I register it with Microsoft?

Macro for footer not at bottom of page

Posted: 15 Nov 2012 02:59 PM PST

We recently upgraded to Office 2010 Home & Business.  I'm trying to record a macro that will automatically put the filename/path in a footer at the bottom of a document.  If I insert a regular footer (not a macro), the footer is placed correctly at the bottom.  But when I record the actions as a macro, the footer with the filename appears immediately after the last line of text in the document.  How do I get the macro to place the footer correctly?

zip code mask

Posted: 15 Nov 2012 02:31 PM PST

I am using Excel 2010 setting up a list of addresses. I use the zip code mask to input zip plus four.  The first number in the zip code is "0".  When I use Word to merge the addresses to envelopes the zip code drops the "0" and drops the "-" between the five digits and the four digits.

error: click-2-run virtualization hand...30015

Posted: 10 Nov 2012 02:15 PM PST

Recently bought a dell (inspiron, windows 7) laptop with microsoft office starter 2010 pre-loaded on it, got it for college, when I try to open Microsoft Word, I get the error "click-2-run virtualization hand...30015".  What can be done to fix this? Is there a way that I can find out what the product key number is just incase I have to uninstall/reinstall?