Results 1 to 3 of 3

Excel dialog is not being displayed

Threaded View

jpcdelft Excel dialog is not being... 02-02-2011, 06:27 AM
jpcdelft Re: Excel dialog is not being... 02-02-2011, 07:18 AM
snb Re: Excel dialog is not being... 02-02-2011, 07:29 AM
  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.

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