+ Reply to Thread
Results 1 to 2 of 2

EXCEL VBA New Window in Current Window

  1. #1
    Registered User
    Join Date
    11-07-2019
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    8

    Smile EXCEL VBA New Window in Current Window

    Hi all,

    I got an issue with Excel userform Microsoft webbrowser.

    Purpose of my userform/macro:
    - Searching cell value in Webbrowser to view info on specified websites.

    VBA Code:
    Please Login or Register  to view this content.
    Navigate their and click datasheet should open the link in current window. (instead of new window)

    (Please excuse me for the * in the link, im not allowed to post links but I need it for my application to browse there and you will need an example.)

    The problem is that:
    - I can't follow a link which normally would open in a new tab. (If I copy the link manually and browse it with the webbrowser it works fine.)
    - I'm unable to catch the link its trying to follow it only cathces the url its currently at.
    - It tries to open an newwindow instead it should open in current window.

    What I tried:
    Catching the URL at BeforeNavigate event
    Code:
    Please Login or Register  to view this content.
    Redirecting at WebBrowser1_NewWindow2
    Code:
    Please Login or Register  to view this content.
    Some pointers in the right direction would be more then welcome.
    Most results I found on google are c# based.

  2. #2
    Registered User
    Join Date
    11-07-2019
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    8

    Re: EXCEL VBA New Window in Current Window

    No one who can help me out with some pointers into the right direction?

    Any help would be appreciated.

+ 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. [SOLVED] Copy Tables from IE window to Excel - Need help making code see already opened window
    By mattyp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-27-2015, 08:14 AM
  2. Excel Display Problem Window Within the Window
    By Ben Harris in forum Excel General
    Replies: 16
    Last Post: 01-16-2014, 08:25 AM
  3. Change cell value in another excel window from first window
    By Weston33 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-24-2013, 10:19 AM
  4. need help in making the current window as active window.
    By ashvija in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-27-2012, 06:04 PM
  5. [SOLVED] Module works on window XP but not window 7 (using same Excel 2007)
    By wongwlv in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-23-2012, 12:32 AM
  6. [SOLVED] In Excel - how to delete new window created from window on tool ba
    By Doug in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-20-2006, 04:25 PM
  7. Replies: 2
    Last Post: 03-17-2006, 01:35 PM

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