+ Reply to Thread
Results 1 to 10 of 10

VBA Error handling for "Send a frown" [Power Pivot/Power BI]

  1. #1
    Registered User
    Join Date
    05-24-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    12

    VBA Error handling for "Send a frown" [Power Pivot/Power BI]

    How do I catch a "Send a Frown" error in VBA?

    Err.Number and Err.Description does not contain the "Send a Frown" error but it displays on the screen halting the current process.

    Capture - Send a frown.PNG
    Last edited by 6StringJazzer; 08-30-2018 at 07:45 AM. Reason: extended title

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    19,679

    Re: VBA Error handling for "Send a frown"

    I did some research on this. You must be using Power Pivot or Power BI, because that's where the message comes from (would have been helpful to include this context in your description). And I have found no way to trap it in VBA. Someone with specific experience in those products may have more to add.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    05-24-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: VBA Error handling for "Send a frown" [Power Pivot/Power BI]

    Hi Jeff,

    Yes, it does originate from Power BI, the background process is "Microsoft Mashup Evaluation Container"
    Attached is a screenshot of the "Task Manager"

    Mashup.png

    When data is refreshed, I get a message box "Send a Frown" at unpredictable, inconsistent intervals. For example, it will work seamlessly for five or six times then suddenly it will fail, and give this "Send a frown" message.

    I need to develop my VBA code to step over this message. A normal VBA error handler does not deal with this. Not even an "On Error Resume next" deals with it. I can thus not capture the error (err) and deal with it in my code. When the "Send a frown" message appears, the entire process is on hold until I (the human) clicks on "Send a frown" or "Cancel". This is problematic since this process runs 3am in the morning on our servers.

    The other option is to find a way to completely disable the "Send a frown" option.

    This is a small cut of the system log that it generates during the "Send a frown":
    Error Log.PNG
    Last edited by Kayees; 09-10-2018 at 04:28 AM.

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,773

    Re: VBA Error handling for "Send a frown" [Power Pivot/Power BI]

    Since the error is not actually generated by your VBA code, I doubt you can handle it, other than perhaps using API calls to await the appearance of a message.
    Rory
    I drink, and I know things

  5. #5
    Registered User
    Join Date
    05-24-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: VBA Error handling for "Send a frown" [Power Pivot/Power BI]

    OK Thank you Jeff, just two questions

    1. Do you know of a forum for the Microsoft Mashup Evaluation Container?
    2. Do you maybe have sample code for an API call to await the appearance of a the message?

  6. #6
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,773

    Re: VBA Error handling for "Send a frown" [Power Pivot/Power BI]

    1. I'm not Jeff.
    2. You could try Microsoft's Answers
    3. Not offhand, and apparently I'm not allowed to give you links to samples on other forums.

  7. #7
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    19,679

    Re: VBA Error handling for "Send a frown" [Power Pivot/Power BI]

    Quote Originally Posted by rorya View Post
    3. Not offhand, and apparently I'm not allowed to give you links to samples on other forums.
    You are allowed to give links to threads on other forums that are are relevant to a question here. We don't want people including links solely for the purpose of promoting commercial sites.

  8. #8
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,773

    Re: VBA Error handling for "Send a frown" [Power Pivot/Power BI]

    There's a big difference between commercial and competing, both of which are apparently off-limits. Anyway, I'll see if I can find the thread I was thinking of and we'll see.

  9. #9
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    19,679

    Re: VBA Error handling for "Send a frown" [Power Pivot/Power BI]

    The spirit of the rule is to not use Excel Forum as a platform for promoting other sites. However, since we require links for cross-posts, that is an exception.

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,474

    Re: VBA Error handling for "Send a frown" [Power Pivot/Power BI]

    The spirit of the rule is to stop advertising and trying to lure members to join other sites. This is clearly not the case here, Rory is trying to show help to a member, that is appears to be beyond the scope of this forum.

    Rory, if you find that link, please share it.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Send mail via Outlook component returns error 429 - "can't create object"
    By marksten in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 06-08-2018, 08:59 AM
  2. Error handling with "out of range" error, need it for a simple code
    By T12ISC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-05-2014, 09:43 AM
  3. Replies: 0
    Last Post: 11-06-2013, 04:37 PM
  4. error handling: comparing value to "" (blank)
    By timothy.siu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-14-2010, 08:51 AM
  5. [SOLVED] Error Handling to mitigate "Run Time Erorr 13 Type Mismatch"
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2005, 09:05 AM
  6. Error Handling for "my" menu bar
    By dstiefe in forum Excel General
    Replies: 0
    Last Post: 07-27-2005, 06:05 PM
  7. Is there a "generic" Error Handling method
    By Brad K. in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2005, 01:06 AM

Tags for this Thread

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