+ Reply to Thread
Results 1 to 2 of 2

GetDetailOf is unable to retrieve Comments property

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    GetDetailOf is unable to retrieve Comments property

    Hi,

    I am using the bellow code to retrieve the comments property of a closed workbook.

    Please Login or Register  to view this content.
    It does retrieve the Comments but I noticed if the comments text contains more than 1000 characters ,it does not work (does not retrieve the comments at all).

    Is there a way around?
    I am using Shell for this.

    Any help would be greatly appreciated.

    Best Regards
    Imran Bhatti
    Teach me Excel VBA

  2. #2
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: GetDetailOf is unable to retrieve Comments property

    Any idea. Please

+ 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. Retrieve DATE PICTURE TAKEN property from a file using VBA in Excel.
    By stuexcel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-20-2019, 11:46 PM
  2. Unable to set the formula property
    By jjjjjjjjunit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2017, 04:10 PM
  3. VBA Tag property. Retrieve data into form and update existing row
    By djm601 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2014, 11:28 AM
  4. Unable to set DisplayAlerts property
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2006, 04:20 PM
  5. [SOLVED] Change property of comments only
    By Martin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2005, 12:05 PM
  6. [SOLVED] Retrieve MS Access DDB Property in Excel VBA
    By ibeetb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2005, 08:05 PM
  7. Unable to set Hidden Property
    By LAF in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2005, 07:05 AM

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