+ Reply to Thread
Results 1 to 2 of 2

Thread: Customize error message using Macro while connecting to CUBE DB

  1. #1
    Registered User
    Join Date
    07-04-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    2

    Customize error message using Macro while connecting to CUBE DB

    Hi All,

    We need some help in Customizing Error Message (that pops up in a dialog box) in Excel 2010.

    When users opens Excel 2010 and tries to connect to SSAS CUBE (don’t have access), Excel by Default pops up error message saying that ''Either the user 'username', does not have access to the 'CUBE DBName' database, or the database does not exist".

    We want to customize the error message to display “You don’t have access. Contact helpdesk.”.

    How to accomplish this?

  2. #2
    Forum Guru Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    5,590

    Re: Customize error message using Macro while connecting to CUBE DB

    Last edited by Marcol; 07-04-2011 at 06:32 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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