+ Reply to Thread
Results 1 to 7 of 7

Transfer Error - Excel to Word

  1. #1
    Registered User
    Join Date
    03-06-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Transfer Error - Excel to Word

    *Before Moderators close this thread - it is a separate question to the two other posts I have under Excel Forum*

    Hello,

    I'm trying to push information from Excel to Word - I've got the macro/vba in the excel spreadsheet working, however when it hits the Word document it comes up with =TransferXYZ for every bookmarked section.

    Can someone explain what I've done wrong in the Word Document. All of my researching lead me to believe that I needed to do a 'range' in excel, then to name the bookmarks the same 'range name' so that it knew where the information was to be dispursed.

    I'm sure it's something easy, I just can't find anything on google to lead me otherwise.....

    I've attached the excel spreadsheet - the macro code is BC Merge.

    I've attached a saved copy of the word document that keeps getting produced when activating the merge.

    Thanks - Pip

    NCR Report - Coding Test.docx
    NCR-CODING TEST.xlsm

  2. #2
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,491

    Re: Transfer Error - Excel to Word

    Simple - instead of:
    xlName.Value
    you should be using:
    xlName.RefersToRange.Value
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    03-06-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Transfer Error - Excel to Word

    Quote Originally Posted by macropod View Post
    Simple - instead of:
    xlName.Value
    you should be using:
    xlName.RefersToRange.Value
    Hi Paul, I made that change and now come back with an Error 13...

  4. #4
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,491

    Re: Transfer Error - Excel to Word

    I suspect that's because some of your names span more than one cell in Excel. You can see this in your posted document too. For example, the cell next to 'Issue Type' displays 'Transfer!$E$2=Metadata!$A$1:$F$1'

  5. #5
    Registered User
    Join Date
    03-06-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Transfer Error - Excel to Word

    Quote Originally Posted by macropod View Post
    I suspect that's because some of your names span more than one cell in Excel. You can see this in your posted document too. For example, the cell next to 'Issue Type' displays 'Transfer!$E$2=Metadata!$A$1:$F$1'
    Hi again, i'm a little confused. How has my report picked up the rows that are the headers of the spreadsheet - which is what the metadata equates to? None of my cells in excel span more than one cell. They are all singular.

    Is there any chance you can show me what you are talking about in my actual register?

  6. #6
    Registered User
    Join Date
    03-06-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Transfer Error - Excel to Word

    Wait - Issue Type and Issue Cause are drop down fields - would this be causing the issue with the 'metadata'?

  7. #7
    Registered User
    Join Date
    03-06-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Transfer Error - Excel to Word

    Mate - I worked it out! Was just a naming convention that was incorrect.
    Thanks sooooo much for your help!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1