I received an odd error message from a website named Unspan stating that my HTML Tags in my test email were not properly closed and nested. I am seeking a second pair of eyes to review the code written below…
I have the following code. My objective is to basically create a replier in VBA that simulates exactly what would happen if user clicked "Reply all" on outlook. It works almost perfectly but I the images from the signatures become…
I have below Json value in string groupsjasontext and I like to parse id, members.value, roles.value using JsonConverter.ParseJson. How will I do it ? I tried to show via messagebox for id field and I am getting error Type Mismatch…
I am very new to Excel macro and need help with the below. I have a nested json string as below. { "Version": 1, "Date": "2023-09-22", "Adjustment": 19, "stock": { "Rate": 1.41, "Price": 19 }, "units": [ { "Place": "NW",…
Potentially been asked before, however I'm after a quick solution to a specific problem with these nested arrays! I have the following data being pulled using Excel into a text file from a url (edited due to confidential info) The…
I need to extract some values from the table in the following website: https://www.anbima.com.br/informacoes/indicadores/. I tried to use the solutions given in Extract table from webpage using VBA but neither worked for me. I am rather new to VBA and…
I am creating a quick VBA script to decipher a json response. This is a work laptop so can't install any other extensions. Via API I get a JSON responds. So far all works. But how do I only list…
I'm new to web things :) so any help would be much appreciated. I'm trying to get the price of a coin from the Royal Mint web site but the element I require doesn't have an ID or a class…
I have an Excel spreadsheet with columns: | A | B | C | D | | Job number | Status | Actual Hrs | % Complete | 1___|____________|________|____________|____________| 2___|____________|________|____________|____________| I have a macro to obtain the following string from…
I have a directory containing tens of thousands of csv files (that used to be HTML files but I wrote a different vba script that changed the extension to csv), that I want placed into one Main xls file (called…