web

I use a web site to monitor when my son gets dispatched on a fire call https://www.toronto.ca/community-people/public-safety-alerts/alerts-notifications/toronto-fire-active-incidents/ I have a macro that works fine on my Windows 8 computer but not on Windows 10 and no one in the world seems to...

Hi, I have a query (get data from web > Table_2) Will a URL like: http://examplesite.com/go.php?account=1331&date=2019010301 Now I'm wanting to control account + date from cell values though unsure how. I've recorded a macro and modified the URL but it is still fetching the same original...

I have this in cell K5: =IF(OR(ISNUMBER(SEARCH({"SLAB - GL","SLAB - GR"},$G5))),"Slab","Floor Plans") I would like to combine that with this: =IF(OR(ISNUMBER(SEARCH({"Open Web"},$G5))),"Open Web","Floor Plans") I ended up with this, but it gives me a #VALUE!: =IF(OR(ISNUMBER(SEARCH({"SLAB -...

Is there an app that can quickly convert excel calculators with formulas into web page calculators? I tried a few that come on Google search but these don’t seem to truly convert or work.

Hello everybody. I'm surfing a web site and grasping data. Now, I'm tinkering with a table. Its name is: id="tbl1" The body is structured as follows: <tbody> <tr class="Row" id="tbl1__0"> <td align="center">A1</td><td>xxxx</td><td>66</td><td>0</td> </tr><tr class="AltRow"...

I have a huge list of ISBN numbers. I need the book name, description, author, publisher and no. of pages, in an excel file. So there should be a file to enter the isbn and accordingly the details would populate below. Any help on this please.:)

Hi, I have web queries which fetch table into excel but sometimes the table URLs don't exist... I.e - when the tables have no data yet How can I handle these errors so that if table isn't found or has no data >>> then it's skipped Any help appreciated

Hello everybody. I'm grasping data in the web via Excel. I'm stuck in inserting a date in a calendar: how can I write the desired date in this one? <td class="Input" style="width:100%;"><span id="Date1_dateInput_wrapper" class="riS RadInput RadInput_Black"...

Kindly see if vba macro can be applied to resolve this.. As manual method is time taking. I have noted the flow of process as Go to Web site url : https://login.msn.com/ Click on sign in option Copy paste email address (eg. xxxx@live.com) from Excel cell A2 Click on Next If the error on next...

Is there a way for excel to auto copy information from a web based program? So we use a program on an interweb and I was wondering if information that is typed into certain areas can be automatically copied and pasted into an excel workbook?

hi , i have a radio button with below elements . i want to click one of them on a web site i try >>doc.getElementsById("datey").Value = 9710 but it just select 9710 value i want to select and click or click on value 9710 , what code i must write? <select size="1" id="datey" name="datey"...

Hello everybody. I'm struggling with scraping data from the web with sendkeys method. I'm now in a situation where, apparently SendKeys "^c" works but SendKeys "^v" has not effect. I mean: at the end of the failing macro, if I manually do ctrl+v, in sheet 3 cell A1 appears what I've copied...

Hi there, I am working on a web automation for my personal work, wherein 1. VBA picks up the web links from the excel A2 cell 2. Open in a IE browser, and fill the values as in Excel cells 3. Click on Submit (Till here everything works fine) 4. New web page opens Now here in the next web...

Hi, I have a web query that runs through Powerquery with a table And the URL ends in a date like: &Date=20190101 How can I control this date from a cell value? I know I need to use the advanced editor but unsure how, it's nothing like VBA. Appreciate any help

If I subscribe and pay Power BI Pro (web), is there any space up there I can upload my data.xlsx there and the Power BI then get data from that file in that web space provided by Power BI Pro ? Please help. Thanks

Hi Guys, i googled and managed to find this simple code. However, i encountered error message " Run-time error '438' : Object doesnt support this property or method". I have tried both Byname and ByID but was returned with the same error code. Below is my vba code. i have masked the web link...

Hi, I have a workbook that contains many refreshable web queries which I refresh using a command button. But how can I "pause" the VBA until queries have finished? As they take up to 2 minutes to complete and I want to manipulate the data afterwards Appreciate any help

Hi there, I use Excel web query to get data from the web page. Sometimes the query works but on occasion, it returns nothing but the phrase in the title. I checked both my chrome and IE browsers, Javascript has been enabled in both of them. Url in question...

I have a need to use data that is entered into boxes on a web page form. If I copy and paste the web page form to a blank Excel 2000 sheet, I can see the data. I can click on a cells of data. But if I move off the data area to an empty part of the sheet and move the cursor with the arrow keys...

I have an Excel 2013 file that has column headings displayed at 90 degrees. That row shows time of day: 6:00 AM, 6:15 AM, etc. Tilt your head to the left and the text looks fine. If I save this file as a web page that alignment doesn't work - it's just something Excel 2013 can't do so the...