internet

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!

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...

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...

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)

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

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...

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...

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?

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?

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...

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"-...

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 =...

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...

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...

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...

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.

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...

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...

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.

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...