+ Reply to Thread
Results 1 to 3 of 3

Excel dialog is not being displayed

  1. #1
    Registered User
    Join Date
    02-02-2011
    Location
    Delft,the netherlands
    MS-Off Ver
    Excel 2003
    Posts
    2

    Excel dialog is not being displayed

    Hi,

    Hopefully someone can help me with this. But first, an explanation.

    I used Excel 2003 to make an add-in (which allows me to connect to a web service).
    Opening a new sheet and using the menu, I can connect to the service. The menu simply runs a sub (ie: "connect_to_ws") which shows an excel dialog which prompts me to enter the WSDL file, name & password.
    so far so good. I can then use functions to retrieve data and save my new excel sheet.

    When I re-load my excel sheet, excel will try to recalculate the functions.
    A function will check to see if there is a connection to the web service.
    If not, it will run the same sub (ie: "connect_to_ws") which is called from the menu.
    Only this time the dialog is simply not shown. And no error is displayed.

    Can anyone help me with this? It seems that when Excel is busy recalculating, no dialog can be displayed. But yet the command msgbox will show messages.

    NOTE: I use "If (ThisWorkbook.DialogSheets("webservice").Show = True) Then" to display the dialog.

    Thanks
    JPC
    Last edited by jpcdelft; 02-02-2011 at 06:40 AM.

  2. #2
    Registered User
    Join Date
    02-02-2011
    Location
    Delft,the netherlands
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Excel dialog is not being displayed

    It seems that the answer to my own question is to use userforms

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,646

    Re: Excel dialog is not being displayed

    Your information is too scarce for me to analyse possible causes.
    You'd better post the whole code.



+ 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.6.0 RC 1