http

Hey, I would like to release a bunch of macros bundled into an add-in soon and I was wondering if it was possible to track the amount of times each macro has been used and send it back to me. I currently do have the counting of the macros used in place but sending it to me is what I am...

Hi everyone, I have another question for everyone. This one is a bit complicated as several aspects of the code need fixing, and I am having a hard time doing so. If there are any helpful mind out there please have a look at he the problem below. What the VBA code should do: Each time text is...

I keep getting the wrong number of arguments or invalid property assignment error but I'm not sure what I'm doing wrong now. Here are some pictures:

The following code successfully downloads the image from the URL and saves it to the location specified. Is there any way I could adapt it to insert it straight into the sheet? Thanks in advance. Sub SavingImagesfinal() Dim http As New XMLHTTP60, htmldoc As New HTMLDocument Dim htmlas As...

URL in E1 is: https://www.tesco.com/groceries/en-GB/shop/fresh-food/all?include-children=true&page=1&count=48 I am trying to get the outertext, which should for example return: Tesco British Salted Block Butter 250G↵Write a review↵↵Sorry, this product is currently unavailable↵↵Rest of ↵Block...

Hello, Getting confused with Div tags etc. Any guide for this? How do you pull a "$0" from html in VBA via XML? Thanks.

Hello, trying to get the price from the website: https://www.tesco.com/groceries/en-GB/products/303105747 So would return £3.00 Any ideas, this is my attempt? Thanks in advance! Sub WebData() Dim http As New XMLHTTP60, html As New HTMLDocument Dim source As Object With http...

I have various lists of website URLs in all shapes and sizes and I want to just have each website to be in this format: www.[insert your domain name].com Examples: Column A www.normals.com (pretty straight and fwd. About 80% of my list is like this and I don't need to...

I can login on my website then then navigate to a web page where I need to select a value from a drop down box then need to click on add button. (using <code style="margin: 0px; padding: 1px 5px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit...

i am new to this forum. please solve my below query. i want fill text box with my given value and click on search button. i cant provide the url as it will not work outside the office. i tried but getting object dose'nt support propery error and method. text box inspect element is : <input...

Hi Guys, I'm working on a data cleanse project at the minute where I'm trying to fill in as many gaps in our data as possible (around 30k records running at 53% blank fields - Dealing with about 6 years of data migrations and lazy employees not focused on data quality) One of our fields is...

I'm studying for the GRE and want to make a flash card macro in excel with a list of vocab words. I found this article, but it seems dated and didn't work for me (I don't think that url works anymore). Here's what I've got so far as I try to build up to a function:Sub DefineWord() 'Assemble...

Hello, Long time creeper, first time poster! I've seen similar questions about IE automation on this board and need help adapting code I have found to my situation. I have code that currently opens IE, navigates to the desired URL, interacts with the form by clicking checkboxes that fit my...

Hello Guys, I’m Sergio Hope someone can help me; I work for a local Maintenance Telecomunication company in Brazil. My problem, we are responsible for the maintenance of 144 internal security system (internal equipment CCTV, dor alarms) Everyday a new Login and Password is automatically...

code: output: 1) how do I fix those characters in the xml response? (before parsing and pulling data from it) the actual output for this node should be "32ième" 2) once that is done, how do I remove all accents from characters? à,ḗ,ḯ,ǿ,ǘ,ḉ,ǹ >> o a,e,i,o,u,c,n

Good evening to all, I have been struggling since last week with this. The purpose of the macro is to automatically sign in, get the Statement, and proceed to the next account, gets the statement, signs out, goes to another Bank...and so on. But I can not even program it to log in. I get the...

Within VBA, I can easily download a file and then obtain properties from that file using URLDownloadtofile to download a file and .getdetailsof to obtain file properties from the file on disk. However, I want to avoid downloading the file if it does not meet certain criteria, so I want to find...