+ Reply to Thread
Results 1 to 5 of 5

How to close annoying popup windows with Excel macro?

  1. #1
    Registered User
    Join Date
    01-26-2012
    Location
    Hki
    MS-Off Ver
    Excel 2007
    Posts
    3

    How to close annoying popup windows with Excel macro?

    Hello,

    I am using the following basic macro which seems to work in getting currency exchanges rates from a website and populating them in my spreadsheet. However, I have 3 issues I require assistance with:

    1. There are 3 annoying popup windows (1 in Internet Explorer, 2 in Excel) which I have not been able to find a solution for how to have my macro automatically close these (run the code and see for yourself). What code changes do I need to make to fix these issues?

    2. How can I program my macro to automatically run every time I open my Excel file?

    3. Is there any unnecessary code/improvements/optimization that could be done on my macro code (since I am not an expert programmer)?


    I would appreciate someone sending me updated code that solves all my questions above.

    My basic macro code:
    Please Login or Register  to view this content.
    Last edited by KB7; 01-26-2012 at 07:10 AM.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,327

    Re: How to close annoying popup windows with Excel macro?

    KB7
    unfortunately,
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    01-26-2012
    Location
    Hki
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: How to close annoying popup windows with Excel macro?

    Thanks! I added the code tags.

  4. #4
    Registered User
    Join Date
    01-26-2012
    Location
    Hki
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: How to close annoying popup windows with Excel macro?

    Still waiting for solutions to my 3 issues. Can anyone help?

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: How to close annoying popup windows with Excel macro?

    What messages are you getting?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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