internet

  1. M

    How to open up internet explorer and download file

    Hi, I have a file which can be accessed through internet explorer. Do you know how to write a macro to download the file through excel? I'm imagining maybe shell command might work. Thanks!
  2. L

    copy a text from internet to excel

    Hi I want to copy a text from internet to Excel. I ctrl+C the text from the internet, then in Excel, I clicked on Paste-->Special -- then select text. Everything copied fine only one issue, some lines are so long. It looks like taking the whole row. I know it is only in one cell A1 for example...
  3. A

    Check internet connection

    The link below shows various ways to detect internet connection. Sometimes you have a requirement to enter a user name and password to access the Internet, how do I check if I'm fully connected to the Internet...
  4. V

    Publishing in the internet via 'On line' excel version

    HI There I have uploaded 'Published' my Excel workbook in the internet , but the ActiveX controls DO NOT show up in the 'on line' version of Excel and hence my users cannot use the internet interface. Is there a solution to this problem. Thanking you in advance Martin Argimon ( South Africa)
  5. P

    Excel online

    Hi There, Ive been searching the internet and cant find a decent answer to the following and wondered if someone would be kind enough to help? Can Excel online work with macros Eg can a button be created that will start a macro to do a series of tasks. Kind Regards P
  6. A

    Web query error

    Sometimes I get an error when getting data from the web. (Either due to lost internet connection or slow internet connections.) The error occurs on Send. if, for example, the website can not be reached, lost internet, or slow internet, I would like to give a message to each scenario. How can I...
  7. M

    VBA HTTP request to scrape webpage links for a URL

    I'm attempting to use HTTP requests using https://codingislove.com/parse-html-in-excel-vba/ as a guide in order to bypass having to use internet explorer. When I use the following macro it doesn't assign T_Object_S to do anything and skips over the for loop. Desired url...
  8. S

    Internet Compatibility mode

    Hi, I have a problem with loading data from a web-page with Power Query. I get an error message that it can't view data beause of Internet Explorer Compabiliy View. And when I try to load I don't get any content, just the html framework. Why is this?
  9. J

    Clicking 'open' button on internet explorer open or save dialog box

    I am trying to press 'open' button on the internet explorer open or save dialog box. I tried sendkeys "%O" which selects the button but not actually pressing it. What did I miss?
  10. B

    Macro to import an html file

    Hi Everyone I have an HTML file that resides on a local drive(C:\Users\HOME\Dropbox\DAILY_SALES_REPORTS\DAY_END.HTML) but opens in a web browser. All I need is to copy the entire main body of the HTML and insert or paste to a particular worksheet(IMPORT_HTML) with a macro. Been all over the...
  11. S

    Excel to Check System settings/requirements

    I have a program that is on a USB drive (iso mounted on usb as .exe from an original CD- no license key needed). I'd like to have a series of macros that do the following but I have no idea how to get Excel to do much outside of the program itself. Macro1: checks system "requirements"-...
  12. R

    How To Activate Go Back Button in This Script

    Sub DynamicWebPage() ' here I define elemnts for the loop Dim sht As Worksheet Set sht = ThisWorkbook.Sheets("Sheet2") Dim LastRow As Long Dim i As Long LastRow = sht.Cells(sht.Rows.Count, "D").End(xlUp).Row ' here I define Internet Explorer Dim IE As Object Dim Doc As HTMLDocument Set IE =...
  13. P

    Help

    Hi All, any help on this would be greatly appreciated. The data below refers to a Used car stocklist advertising changes. Each line represents a log of a price change on the internet. I need the following data retrieved from this list. 1 - Total number of internet changes for each car 2 - The...
  14. S

    Select a button on Internet Explorer via VBA

    I am trying to select a button in Internet Explorer via VBA but it is not working. HTML and the VBA codes are below for your reference. Your help is much appreciated. HTML: Go VBA Code For Each HTMLElement In...
  15. J

    Indirect()

    Hi, I have 2 Columns, Column A is a value selected from a Drop down List, and Column B is also a value selected from a drop down list based on the value in Column A. I use an INDIRECT formula =INDIRECT(SUBSTITUTE(A2," ","")) to determine which values it brings back in the drop down from the...
  16. A

    Web scraping

    Hi, is there anyone who knows how to get excel to search a list of phone numbers on the internet and return who they are for.
  17. I

    Check a cell in one column and concatenate the rows in another column and ignore some cells.

    I need some formula or vba code to get the desired output. Formula should check column D if a cell in column D starts with "0" then concatenate all rows in column L (with spaces) until another cell in column D that starts with "0". Red highlighted cells are the garbage that are produced by the...
  18. N

    VBA check Internet connections

    Hello, I'm looking for a VBA code that returns if there is an internet connections. There is a lots of code out there but the problom is that I didnt found a code that actualy works no matter what type of Excel version the user have (I mean 32 BIT or 64 BIT). I will be happy for help on this...
  19. T

    vba-Connect to internet using 3g usb modem (AT commands)

    Hi I need to connect to the internet through a 3g usb modem (Huawei E173) using AT commands. Is that possible?? I searched a lot but didn't find any instructions about how to do that. Thank u in advance.
  20. M

    Help with VLOOKUP with OR

    I would appreciate some help with a VLOOKUP syntax issue I am trying to add another condition (OR) to my existing formula The formula below works correctly =IFERROR(VLOOKUP(H9,Table!A:W,23,FALSE),"") I want to expand it to look at both H9 or F9. Is there a way of doing this? I searched the...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top