web

I am using Excel 2016 as a means to capture data from a piece of equipment that has a web IP address/USB port. If I use a web browser, the URL would be http://127.0.0.1:44789/evox/bacnet/2/0/51/117 and would get back a response <int< font=""> xmlns:trane="</int<>trane:evox"...

Hi Anyone tested to use a Web Query to get list of files from a SharePoint site to Excel? It would be really nice to get the list updated everytime the user open the Excel workbook. BR/Tom

I'm trying to get data from a web page and keep getting the message from the web page 'the browser your using is not supported any more, update your browser'. I'm using Excel 2016 and IE 11, which surely must be as up to date as you can get. Subsequently the headings download but the data tables...

Simple Question. Can I set up a web query to log me onto a website before extracting the information? The issue is every time you go to the website i want to get information from, regardless if you're logged in on another tab it asks me to log in again. So i simply need to web query to...

hi All, I am looking for a VBA code that allow me to click a tab (provided as image) on a web page. The web page is not showing any id specific to the tab. Here is the source code. td height="36" valign="bottom"> a href="javascript:submitTab('pair_search')" tabindex="6" img...

Hello all, I'm trying to read a web page in the INTRA net to get data. (no unfortunately, I don't have access to the data source) It's not like anything I have ever done before. I can't scrape it because there is nothing to scrape. It's all nothing more than html pointing to scripts as shown...

I'm trying to load some tables into an Excel workbook every morning. Here's one the URLs https://www.fangraphs.com/leaders.aspx?pos=all&stats=bat&lg=all&qual=y&type=1&season=2018&month=13&season1=2018&ind=0&team=0&rost=0&age=0&filter=&players=0 I have Excel for Mac. My understanding is that I...

Hi, I have a list of serial #’s that can be embedded into a URL that has an image attached. As of now, I’ve got a worksheet change that when double click on cell that contains serial #, it’ll scrap the image into a new workbook for my users to view what it is. I’d like to steer away from that...

Hello Sir, I need to know how can I login into the following website using vba. following is the website; firstly I have to open/navigate the following web. Once it is opened I need to click login page . https://www.tdscpc.gov.in/ regards, motherindia

Hello, I've only just discovered that I can import data from a web page by: Import External Data ~> New WebQuery Much scarier than the reality in practise! I do however have a question, if the data I want is split across multiple web pages like this one here...

Hi Everyone Ok so I need to remove the name from a cell with other data in it. so lets say data is in A2 here are some examples of what it can look like what I have: The result I want WEb Site - Sales - Tony Tony Web - enquiry - Tony-Snith Tony-Snith...

I am trying to run a web query in excel 2010. As soon as I select get external data from web and the browser opens up within excel, an error message window pops ups with 'an error has occurred with the script on this page'. This message keeps popping even if I click yes to continuing to run...

Hi, I'm using the following code to refresh a web query. My problem is that i have a pivot-table that's sourced from the web query results. I thought the code would refresh both the query and the pivot but I think it's refreshing the pivot before the web query is finished. Is there a way to have...

Hy, I have this code which works fine when you manualy type the information allowing only numbers. If I use the paste function in the textbox("DN") userform I can enter everything, letters ... . The code bellow is set to KeyPress, is it possibile to verify the textbox when I click a button or...

Hi Guys. I need to create a button command that will launch a website that is selected from a DV list. I currently have a DV list in cell D15, that the user can select a useful web address. I then have a button which when clicked needs to launch the selected website in Google Chrome...

Hi all and thank you in advance for any assistance. I'm in over my head on a project and looking for some help/guidance. I want to pull information from a website based upon the information input into my worksheet. A1 = OriginZip A2 = DestinationZip A3 = Zone When zip codes are entered in to...

Hi All, I wrote this crawler 6 months ago and now it gives me error message. Dim IE as InternetExplorer "user defined type not defined" error, I use the same exact line in another excel book. Any ideas?

Good Day!! I am a little lost, and hoping someone can at least point me in the right direction. Every month, I need to review 20 hotels on TripAdvisor.com and see what their rankings are. One example here for Hilton Cleveland is #3 of 38 (as of right now, may change at some point). Here is...