browser

  1. P

    Import data from excel and update in browser

    I have two columns in an excel file A - contains the web link B - contains the data to be updated in opened browser as per A. While opening in the web browser (1 as per image) there is drop down option comes at a particular section (2 as per image) > select an option > it will open up...
  2. D

    Excel (2007) Web Query data -- how to stop annoying script errors in the built-in browser?

    When I click the Data...From Web option in Excel 2007, it launches an internal "browser" that I'm supposed to use to navigate to the site that I want to grab data from. The problem is that this built-in browser uses MSN.com as its default "home" page, and it generates several (sometimes 5+)...
  3. W

    How can I fetch a web site in VBA without using IE? I now use IE & MSXML... to do fetches.

    Chase Credit Card issued this announcement: Please update your browser.We'll stop supporting Internet Explorer® soon. Choosing another browser will also help protect your accounts and provide a better experience. Update your browser I would prefer to use Chrome ver. 77. Any advice?
  4. L

    workbooks.open with file browser

    Hi I want to improve the code below. I am thinking if it is possible to display file browser for the user to choose file from. Like when you click open in Excel, a file browser will be opened to help users to select a file. Can I do that here? Thank you very much Sub wbs_open() Dim xfile...
  5. K

    getElementbyID excell vba click on the link in a sidebar

    Hi folks. I am at a loss here and am not sure what i am doing wrong. i am trying to click on this link: "Document Browser " isn't it as simple as... (this is what i started with) Sub clickthebutton() Dim IE As New SHDocVw.InternetExplorer Dim HTMLDoc As MSHTML.HTMLDocument Dim HTMLInput...
  6. G

    How to show if open in browser or Excel application?

    I'm looking for a way to show if a file is open in a browser or if it is open in the excel application. Or alternatively, a way of ensuring the file opens in the application. My reasoning is that the file is a compiler and has macros which can only be run through the app and my colleagues...
  7. R

    VBA automate IE actions

    Hello, I found this VBA from automatetheweb and I found it very useful to my daily work. I want to automate the search we daily do with VAT numbers from the EU vies validation page. So the VBA is suppose to go to the website http://ec.europa.eu/taxation_customs/vies/, then insert A2 in...
  8. L

    XlBorderWeight enumeration

    Hi I wanted to assign value to this line Workbooks(1).Worksheets(1).Cells(xrow, xcol).Borders.Weight = So I used Object Browser, and typed Borders then clicked on weight and I read the following: Property Weight As Variant Property Weight As Variant that is all! nothing else. I had...
  9. G

    VBA Help System

    Hi, I have clicked on the SaveAs method word in some code in the Visual Basic Editor and would like to see all of the associated File Format types. After pressing F1 I expected to get context sensitive help but instead a new web browser for Visual Studio 2012 opened which doesn't seem to be...
  10. C

    Error: "custom properties linked to cells" - Excel online

    Hi, I have uploaded a template to be used within the organization on an online sharepoint and get the following error when trying to open the file in the browser: We're sorry. We can't open the workbook in the browser because it uses these unsupported features: • Custom properties linked to...
  11. J

    Requested Help with changing default Web browser for Macro web site scraping

    I have done many google searches for trying to change macro web site scraping code from using Internet Explorer as the default web browser to an alternative web browser for scraping data. Unfortunately, all I have found is changing the web browser for hyperlinks in an excel cell. Is there a way...
  12. L

    Selection.Address in vba

    Hi Why Selection.Address is acceptable syntax. I checked using object browser, that Application.Selection is a property of type "Object". I tried to search for Object, could not find any entery in object browser. My question, What is Selection and how can I find what its functions and...
  13. C

    Question about the Excel object model

    Hi everyone I am trying to learn about the Excel object model and i am bit confused the following code line: Excel.Application.Selection.CurrentRegion.Select In the object browser i can see that application is an child class and a property of Excel. I can also see the selection is a property...
  14. I

    Apply formula to cell opens browser tree

    Hi, In cell K33 i have pasted the following code. =SUM('INCOME (1)'!G32 -'EXPENSES (1)'!K32)-MILEAGE!C32 When i then hit enter *** opposed to see the code apply itself & return a value the browser tree opens and advises me to update value income 1 Whats happening ? Thanks
  15. A

    Why does this Googlesheets workbook take so long to update?

    https://docs.google.com/spreadsheets/d/1mrmVxKVgG1JWtIpXi6pca2mck8WJhbFQACsxtCqXCOQ/edit?usp=sharing I've got a tonne of VLOOKUP references - and maybe the conditional formatting isn't as efficient as it could be (it was the only way I could figure it out). Everything does what it needs to do...
  16. S

    Compile Error: Can't find project or library

    Hi guys, I m new to VBA but have some basic of C programming n JavaScript. I encounter the above error. Below are the coding which I had written. Please assist. Thanks. Sub Address() Dim IE As InternetExplorer 'start a new browser instance Set IE = New InternetExplorer...
  17. S

    VBA - Embed web browser and access session?

    I've got a web page that I can send a generated URL and the page returns some XML that I then parse and insert into my spreadsheet. All of the URL creation and XML parsing works but there's a problem with trying to run this in the real world. The website requires that the user is logged in in...
  18. S

    Navigate to URL without opening a browser

    I need help with vba code to be directed to a URL without opening a browser. Having it pointed to the URL is sufficient to get me where I need to be. "Followhyperlink" will navigate to the URL and open it in a browser. I just don't want a browser to open. I can use the URL in the...
  19. A

    Insert GIF image in excel sheet using VBA but without Web Browser Active X, possible?

    Hi everyone, I know that this topic has been discussed many times regarding inserting GIF-images in excel sheets. But all i can find is people giving the solution of using the Web Browser Active X control. This control does not work in Excel 2016 (unless you enable it in regedit or whatever...
  20. D

    Excel always pre-loads links with IE7 engine, causing unsupported browser messages. How can I stop this reproducable issue?

    For example, if you paste either of the links below into an excel spreadsheet and click on the link, you will get a "Browser Unsupported" message from the website. https://www.logistics.dhl https://awardsolutions.instructorled.training/ This happens regardless of what browser or OS...

Some videos you may like

This Week's Hot Topics

Top