+ Reply to Thread
Results 1 to 6 of 6

Count words and characters of hyperlinked word documents?

  1. #1
    Registered User
    Join Date
    10-28-2015
    Location
    Paris
    MS-Off Ver
    Office 2013
    Posts
    5

    Post Count words and characters of hyperlinked word documents?

    Hello,
    I have an excel document with many hyperlinked word documents.
    Is possibile to insert in a new column the number of rows and characters of word document in hyperlink?
    Example:
    Please Login or Register  to view this content.
    Thanks
    Bye

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Count words and characters of hyperlinked word documents?

    This worked for me.

    Please Login or Register  to view this content.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Count words and characters of hyperlinked word documents?

    I realize you're probably using friendly names, so this will actually pull out the filepath from the hyperlink property:

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    10-28-2015
    Location
    Paris
    MS-Off Ver
    Office 2013
    Posts
    5

    Re: Count words and characters of hyperlinked word documents?

    Thank you.
    It's perfect!

    Only another question.
    Is possibile to know if in the hyperlink word document there is an attached image?
    Only create a column with Yes/No.

    Thanks.

  5. #5
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Count words and characters of hyperlinked word documents?

    Quote Originally Posted by asterixo500 View Post
    is an attached image?
    Do you mean contains any images in the Word document?

  6. #6
    Registered User
    Join Date
    10-28-2015
    Location
    Paris
    MS-Off Ver
    Office 2013
    Posts
    5
    Quote Originally Posted by daffodil11 View Post
    Do you mean contains any images in the Word document?
    If there is an image into hyperlinked word document, on excel sheet I would insert a cell with Yes/No.

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 VBA/Macro to print multiple hyperlinked Word documents.
    By Mark4292 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2013, 07:55 AM
  2. Replies: 1
    Last Post: 01-30-2013, 04:41 AM
  3. [SOLVED] Replace Random Chinese Words (Not Characters) with Blank Spaces in MS Word
    By mlexcelhelpforum in forum Word Programming / VBA / Macros
    Replies: 8
    Last Post: 08-05-2012, 06:42 AM
  4. Date Last Modified of Hyperlinked Documents + Collaboration of Hyperlinked Documents
    By mr butter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-15-2010, 05:35 AM
  5. How to open a Word.doc using VBA and count the words in the word.doc?
    By eijoah in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-05-2007, 12:58 AM
  6. [SOLVED] How do I print hyperlinked documents from a cell in excel
    By Queenshero in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-29-2005, 03:06 AM
  7. Finding Words In Excel Spreadsheets & Word Documents
    By rbonner79416 in forum Excel General
    Replies: 0
    Last Post: 03-18-2005, 01:06 PM

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