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. brentfraser

    Import range of cells in excel to word

    Thanks Skip, et. al. It works wonderfully! Very excited. You have all made my Tuesday afternoon!!! Brent
  2. brentfraser

    Import range of cells in excel to word

    Hey Skip and PHV, thank you so much for the tips.... it's working and getting the information into the content control. Is it at all possible to have each line come in as a separate line and not concatenated in a single line? All of you have made my day so far! Brent
  3. brentfraser

    Import range of cells in excel to word

    Thanks Skip, It seems logical to what you are suggesting. I tried it in the word document and I get an error stating "Compile error: Method or data member not found" and it is highlighting .Value in: dim r as range, sTextForDoc as string for each r in...
  4. brentfraser

    Import range of cells in excel to word

    Hi Combo, No I don't need the formulas, I just want the text from the cells (I have 6 in question; A1:A6). I still think I need an array but I am not sure how to do that at this point. Still working on it. Thanks for the tip. B
  5. brentfraser

    Import range of cells in excel to word

    I am trying to import a range of cells from Excel to a Word content control. Currently I can import a single cell using the following: dataInExcel = workBook.Worksheets("Sheet1").Range("A1").Formula As soon as I change "A1" to "A1:A6", it stops working. Is there another convention that I should...

Part and Inventory Search

Back
Top