Results 1 to 9 of 9

Thread: [RESOLVED] Easy Yes/No Newbie Questions: Can I do this?

Hybrid View

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Sep 2005
    Location
    Virginia, USA
    Posts
    17

    Re: Easy Yes/No Newbie Questions: Can I do this?

    ListGalleries is what the Word macro generated.

    Yes, it worked!

    Now, I'll try linking images... but only when I get back from vacation, so until next time!

  2. #2

    Thread Starter
    Junior Member
    Join Date
    Sep 2005
    Location
    Virginia, USA
    Posts
    17

    Re: Easy Yes/No Newbie Questions: Can I do this?

    I'm back...

    And I was able to add images into my Word document that were listed in Excel. The "asking" Word idea has been a great help. It makes VBA easy for me to use... with some exceptions. I need the filename/path in Excel to be checked for validity (does the file really exist?) so the Macro doesn't "break".

    Working on that next...

    VB Code:
    1. If LEN_TEXT_IN_COL_G > 0 Then
    2.                 'Insert image for page
    3.                  Set oPara2 = objDoc.Content.Paragraphs.Add
    4.                  With oPara2
    5.                     'How do I verify that the filename is right?
    6.                     .Range.InlineShapes.AddPicture fileName:=STR_IMAGE_PATH, LinkToFile:=False, SaveWithDocument:=True
    7.                     .Range.InsertParagraphAfter
    8.                 End With
    9.             End If

    Thanks!

Posting Permissions

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



Click Here to Expand Forum to Full Width