Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Sorcerer13

    Getting hold of Excel data from Word VBA

    Thanks SkipVought - looks like we both got there - you through skill, and me through luck! Steve There's nothing quite so rare as common sense!
  2. Sorcerer13

    Getting hold of Excel data from Word VBA

    It seems that the problem is in the Dim statement. On testing Err.Number, it's usually 1004, but when stepping through the code looking for a named range which I KNOW exists, I got Err.Number = 13 (type mismatch). I changed the "Dim rngTest as Range" to "Dim varTest as Variant", and everything...
  3. Sorcerer13

    Getting hold of Excel data from Word VBA

    P.S. I know the Function name is really "NamedRangeExists" - I was part way through modifying the names when I posted this query. Steve There's nothing quite so rare as common sense!
  4. Sorcerer13

    Getting hold of Excel data from Word VBA

    I want to populate portions of a Word 2010 document by copying in data from an Excel 2010 spreadsheet. I can happily open the spreadsheet within the VBA in Word, and I can copy in the data, but what I now want to do is to only copy in the data if it exists as a specifically named range in the...

Part and Inventory Search

Back
Top