web

While i am trying to pull data from this site "http://www.kooora.com/?m=1288850&stats=summary" gave me this massage "an error has occurred in the script on this page" i entered "yes" more than 30 times and finally gave me this massage "This Web query returned no data. To change the query, click...

I have several columns that contain formulas in the cells- One Column (right in between several others) will not take the a formula. It insists on displaying only the value of the formula. Might be the weirdest thing I have ever seen in excel. All other columns (Left Side & Right) side...

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

Hi I found very interesting function from web. It has been done by some Finnish guy, so some functions are in Finnish. Short translating PYÖRISTÄ.DES.ALAS = ROUNDDOWN PYÖRISTÄ = ROUND JOS = IF EKSPONENTTI = EXP Another Finnish words are cells names ( Name Manager) Link to the this web site...

Hi everyone, I'm using VBA to populate a web form and 99% of it is working just fine. I have one problem, though, when trying to populate a field that depends on a previous one. This is an internal (corporate) web form so I can't use a real example, but here is an exercise: Imagine I want to...

Looking to write some VBA in excel to loop through refreshing a web query that has 2 variables I am trying to populate. After doing some digging online I found the following code which appears to have worked for some other users. With ActiveSheet.QueryTables(1) .Connection = "URL;" & NewURL...

Hi All, I have created a small excel sheet to embed into my web page, I have chosen to embed it using Onedrive as it seems the easiest way (copy and paste some iframe text) My problem has occurred when I created a simple 'Reset Button' which resets the form to blank, when I updated the...

Hello, I have received some fantastic help so far and I appreciate the lessons. I am trying to apply copy and pasting rows with code for my new application but no success yet. What I would like to do is copy the checked maintenance row from Sheet1 to the end of the table in Sheet2 then clear...

I am a the director of Maths in a school in the UK. I am looking for an online solution for my staff to produce feedback sheets for students in their classes. Currently I have an excel spreadsheet with some VBA code that enbales the teachers to input the scores that students get in a given...

I posted this in the excel board asking about the old get data from web menu which was out with PQ, but i guess it is more relevant to PQ I have created a query that returns competition scores from various web pages within the How did i do web site (golf scores). On my old laptop, which has...

How can i bring up the old excel 2010 web query menu in excel 2016, the one with the wee yellow arroes to select the part of the web page you want. I did it once before with keyboard shortcuts but cant find it again Many thanks I think if i use this and log in, PQ is able to access page

hi, So I have this excel file made by developer. It's quite complex and has a scraping procedure. I have two copies of it, one at home and one at work - I was wondering if you could recommend me any online services to deploy this file and use it as Web App instead? I know it's possible but...

Hi I am looking at pulling price data from a html web page. I have no idea how to navigate and get the data I want. I only know it is possible to get the full table by the normal way of "get data from web" tab but I would rather get just one specific (strike) row under a specific date than the...

Hello, I am using Office 365 and I am trying to get a data table from the web and import it in an Excel sheet together with the images. Here is the table which I am trying to import: https://royaleapi.com/clan/90R9VPP9/war/analytics As you can see from the table, there are images in cells...

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

My employer asked me to strip https://www.citb.co.uk/cards-testing/online-card-checker/ to check all employees of valid constitution cards. All code is working fine but at some point after number of "For each" my VBA returns error. It turns out that cookie notification go at front of the web...

I know this is a formatting issue but wanted to know if there is a work around. I import daily a couple of web pages with various data that is working fine for me. The only issue I am having is one of the fields which could on the web page for example be a 6-4 7-2...etc. Those fields come...

Hello, I know this has been asked, because I have found prior threads. But hence my username, I'm pretty helpless when it comes to web data connections, especially password protected ones. I would like to do a web connect for a power query on fantasy football data. Here is the website...

Hi, I'm trying to use VBA to log me into a secure webpage, then navigate to a webpage where I need to select a value from a drop down box before searching the database. I cannot get the last part where it selects the value in the drop down box to work, I have used the below code. The...

So if I have a web query in cell A1 and run the following macro: Sub Caption() Worksheets("Sheet1").Range("A1").Select CommandBars(1).Controls("Data").Controls("Import External Data").Controls("Edit Query...").Execute End Sub It breaks the query and displays the following error...