Pages

Search

Microsoft Word - Merge cells in able with vba macro

Microsoft Word - Merge cells in able with vba macro

Merge cells in able with vba macro

Posted: 17 Jan 2015 02:53 PM PST

I have a table that I want to have repeat on pages of a report. Rather than copy and paste I would like to use a macro.

I can create the macro with the table, formatting etc., but cannot find guidance to merge cells.

eg., In my three column, multiple rows table

I need to merge cells as below

   
  
     
     

I am almost there, but as I need this for a report I thought I would ask for some expert help :)

Regards Jan

How to create an index of an entire text, i.e. of all words in a word (2013) document?

Posted: 17 Jan 2015 02:45 PM PST

In order to find (missing) keywords, count frequencies etc. I need to make an index in Word documents of the entire text of that document, of every word from 1 letter onward.

At first I tried to work with a concordance file (search and replace to get every word on a separate line) , but that is very unpractical because of all the multiple entries and the fact that they are case sensitive, meaning they all have to be copied with a capital letter.

Here and there on the internet I found some references to macro's, but they do not work (at least not in v. 2013). I also found a reference on this site saying that (in word 2007) no macro would be needed, but following the link I found no answer....

I hope someone can help.

Word 2010 right-click context menu opens then closes immediately

Posted: 17 Jan 2015 12:47 PM PST

Hello,

I am editing a Word DOCX file that came from another computer. I saved it to my PC with editing enabled.

When I right-click in the document the context menu opens for a moment then closes again. 

This occurs also with files created on my PC.

How can I fix this problem?

My operating system is:

Microsoft Windows 7 Home Premium 6.1.7601 Service Pack 1 Build 7601

Microsoft Word 2010 (14.0.7140.5000) SP2 MSO (14.0.7140.5002)

Thanks!

Word 2013 not opening with windows 8

Posted: 17 Jan 2015 11:43 AM PST

Word 2013 is not opening in windows 8 either in normal or safe mode.  I have tried deleting the ABBYY FileFinder file and still no joy.  I have spent the day searching through all threads and support through the Microsoft support pages but nothing helps.  I get the We're sorry but word has run into an error that is preventing it from working correctly.  Word will need to be closed as a result.  Would you like us to repair it now?

When I select the repair option nothing works.  I also get the same message when trying to open in safe mode.

All other programmes like Excel, PowerPoint and Access all open without issues.  Please help.

Merge - only first record printed to ALL labels

Posted: 17 Jan 2015 10:34 AM PST

Windows 7

MS Office 2010

Mail Merge - Labels

Task: 6@ labels/page, 48 records

Problem: all 48 labels contain only the first record

When I merge to edit before printing, or even print a single page (6 labels) of the first six records, I only get the first record on all labels. If I search for any other record they are all there, they just don't fill the merge document.

Any suggestions?

Thanks!

Microsoft Word Mail Merge Issues with Excel Files

Posted: 17 Jan 2015 09:12 AM PST

Using the Mail Merge function in Word to develop an envelope for a mass mailing using an envelope template.  Using an excel file for the database with the Mail Merge function.  Works OK, but in one of the fields...the zip code field in this case...I find on some records the zip code gets inserted OK, but on others it just shows as a zero.  See example below.

Mr. Sanjay Gupta
Vice-President, Platform Development, Major Appliances
Haier America, Inc.
1800 Valley Road
Wayne, NJ 0

In looking through the zip code field, I find the zip codes with "pure numbers" like 30303 merge OK into the envelope document.  Others with an zero in the first position in the zip code as well as zip codes with a hyphen in it like 30303-4567 print out like above....just a zero.  At first I thought the excel field with the zip code in it needed to be changed to a number format field vs. general.  However, doesn't make a difference; zip codes that aren't "pure numbers" still print out like zero when merged.  Any ideas?

Regards..Rick

Batch process word files in a folder to set top margins

Posted: 17 Jan 2015 09:00 AM PST

I got the following code from the net and changed it from changing paper size to setting top margins of word documents to suit my needs

Sub ChangeTopMargin()
Dim myFile As String
Dim myPath As String
Dim myDoc As Document

'Change to the path where your documents are located.
'This code changes ALL documents in the folder.
'You may want to move only the documents you want changed to seperate folder.
myPath = "C:\Users\Rajesh\Documents\Clinical Material\OPD"

'Closes open documents before beginning
Documents.Close SaveChanges:=wdPromptToSaveChanges

'Set the path with file name for change
myFile = Dir$(myPath & "*.doc")

    Do While myFile <> ""

    'Open the document and make chages
    Set myDoc = Documents.Open(myPath & myFile)
    myDoc.PageSetup.TopMargin = 168

    'Close and saving changes
    myDoc.Close SaveChanges:=wdSaveChanges

    'Next file
    myFile = Dir$()
    Loop
    MsgBox "Process complete!"
End Sub

Now when I run this code after saving the file and closing code editor, the existing document closes but nothing else really happens. Ideally each of the word files in the folder OPD should be opening, get changed, saved and closed till the Process Complete message box comes up. I am out of my depth here. I will appreciate any help.

Thanks

After a mail merge, can the file's Save As name be prepopulated with merge data?

Posted: 17 Jan 2015 07:47 AM PST

When we want to send out a letter, we merge a template letter with a single person from our database, and the letter fills right in. Then we save the letter for our records. When we go to save the merged letter, it starts with a default name of "Form Letter1". Then we have to manually change it to something else, like "Smith - Intro Letter - 2015".

Problem is, doing that each tie we send out a letter takes time, plus as it turns out different people as using different schemes for file naming.

Is there any way to have the merge filename prefill with something like "<last name> - Intro Letter - <current year>" so that when someone goes to save it they don't have to enter in a name at all?

Thanks.

Is there a bug in StoryRanges?

Posted: 17 Jan 2015 06:27 AM PST

Hello, most of my reports include multiple sections in which headers/footers are unlinked. I created this file with two sections and unlinked the headers/footers. I put some text in header/footer of second section.

In contrast to the statement at http://msdn.microsoft.com/en-us/library/office/ff197823%28v=office.15%29.aspx "Returns a StoryRanges collection that represents all the stories in the specified document.", ActiveDocument.StoryRanges does not refer to header/footer story ranges if the header/footer of the first section is empty.

Please Run This Makro with this file

Sub ListStories()

Dim sR As Range

For Each sR In ActiveDocument.StoryRanges

Debug.Print sR.StoryType

Next sR

End Sub

It will return 1, 12, 13, 15,16 instead of 1, 7, 9, 12, 13, 15, 16

help with needing to reinstall microsoft word without a product key.

Posted: 17 Jan 2015 04:23 AM PST

Hi

I bought my laptop about two years ago.

I had to completely refresh my computer without losing my files. 

I now need to reinstall Microsoft office 2010.  problem is I no longer have my product key and never had a disc to install it.

any ideas how to get it please

thanks

P

The "Auto fill / auto suggest" file names shortcut associated with opening a Word document has stopped working.

Posted: 16 Jan 2015 11:38 PM PST

* Not sure if this makes sense, but until about a month ago - whenever I would Open a Word document - typing the first few letters of its file name would result in the blank field being filled up with suggested file names already in the folder I'm trying to access, e.g., it was a "shortcut," - the blank field in which I would enter the file name would momentarily turn into a drop-down suggestion list of available documents in the folder - adjusting itself after each succeeding letter being typed.

* For example, if I wanted to get at a document with a long file name called, "poster inventories and frames.docx," until about a month ago, I didn't have to type every word in this file name to open the document.  Word 2010 used to instead "auto-suggest" the documents to open based on the first few letters of the document file name being entered.  I could then easily see suggested documents highlighted in blue until it hit the only available match - and I could click and instantly access it.  It was a real handy shortcut.

* I really don't know what to call this shortcut function; it is not auto-correct, but it was like visiting a search engine that suggested words as you type, but occurring "offline" within Microsoft Word while opening documents.  BTW, I'm not talking about the Recent Documents function which lists frequently opened files.  The behavior I'm describing used cover any document I would try to open in a target folder, regardless of when it was last modified/viewed/created.

* I've searched everywhere for an answer and have come up empty.  I suspect it might have something to do with the normal.dotm file but I can't find any options for what I'm describing even in the broad Word Options or Word Help sections of my program to restore this behavior. 

* I hope what I'm describing makes sense.  Anybody familiar with what I'm describing?  If you do, please let me know and thanks! 

Best, David in San Diego.

Microsoft Word

Posted: 16 Jan 2015 04:21 PM PST

I have installed Microsoft Office 2010 on my computer, which is Windows 8.1.  When I try to open a document I get the message that Micrfosoft 2013 needs to be purchased and the document will not open.  How do I get this message to go away and have documents open with the Microsoft Office 2010 that I have installed?

Microsoft Word 2010 font drop down not working when computer is added to the domain

Posted: 16 Jan 2015 03:11 PM PST

I have been asked to resolve a problem with Microsft Word 2010.  The font drop down works fine locally but when it is added to the domain the option is unavailable.  Does anyone have any experience of this or any suggestions?

Thanks

Thomas

Working with office offline

Posted: 16 Jan 2015 07:29 AM PST

Hello,

I would like to be able to open a word document even when I do not have an internet connection. All my documents are saved in my computer and not in my Onedrive. Moreover when I try to open a document while offline I get a window saying that I can enter my product key instead, however the pop up window with the message saying " Getting your new office ready for you" doesn't seem to be able new office ready for me... Also, every time I open a document ( with internet connection) my account is being verified. Why is this?

Could you please give me a clear answer with the steps to follow in order to be able to use my computer even though my connection internet is gone please, saving everything as a pdf is not the most efficient use of my microsoft office.

Thank you.

Subscribe to: Posts (Atom)