mso | Examples and assignments for the MSO course | Learning library

Okay so I'm not going into any details pertaining to expanding the table, as you seem to have managed that correctly on your own.

The second question can be solved with a search table and a partitioned ROW_NUMBER().

When we assume the following base table setup:

tl;dr;

There is much greater support for css selectors and for Element.querySelector (allowing for greater flexibility in chaining querySelector(All) calls. This enormously enhances the expressivity of the MSHTML class, in terms of CSS selectors, and brings it on par with Selenium Basic.

Motivation:

I have been wanting to write a list of supported selectors for some time, due to the lack of documentation on this in relation to VBA, and the trial and error nature of learning what does and doesn't work. This latest change has spurred me to do so, and include those libraries which currently support use of CSS selectors within them.

CAVEATS:

1. This is not exhaustive; it is pretty comprehensive.
2. Should you find any errors, particularly with respect to Selenium Basic, which I had to write from memory, please notify me and I will edit accordingly.
3. The recent changes, represented by shaded cells within the summary table (JSFiddle)| marked with ✔* , within simplified table below, are as they pertain to my set-up, at this point in time. Your mileage may vary e.g. CSS selectors were not supported at all < IE8.

Before and After:

Traditionally, the expressivity of CSS selectors within VBA was as follows, with respect to the libraries supporting them:

Selenium implementing, by far, the most CSS selectors.

Current state:

The current state of implemented selectors I believe to be as follows (sorry for image quality, even when you click to enlarge table - please see JSFiddle for clearest table view):

I include this as a simplified HTML insert as well, so you can click on hyperlinks. Please click the Run code snippet below the code insert, then the Full page link. Apologies, the table is large and I haven't even covered all conceivable selectors - only the main ones I consider likely to be frequently of use. Inserting a fancy table threw me over the body character limit so here we are. For a fancy table please see this JSFiddle - the newly supported are shaded.

Please try this

If I get this correctly, you could replace :

Okay, I'm getting an error when trying to use your original code. Outlook isn't liking it at all. There is a service buttons.cm which will help you with button formatting however many in the industry feel that code is outdated and code like the snippet below or Mark Robbins button code, is a lot more flexible in all email clients. I personally use Mark Robbin's code, but it can be quite jarring for those who don't have a lot of experience with html email, so the snippet below will work just fine.

1. Pretty much universally friendly.
2. Still requires Outlook workarounds.
3. The link uses borders to padd the linked area for better support in more clients.
4. Padding values used in the Outlook code, should almost match the border width values. I've personally found 5px left on all sides, mimics the button height and width in Outlook with all other email clients.
5. This method of button coding requires only one update to the URL whereas your old code and the buttons.cm require two URL updates

Regex is a whole world by itself. There are usually several approaches to reach the same result. Here is one of these approaches:

Do not despair VBA web-scrapers (I know there are a few!) We can still have the luxury of css selectors and the benefits, though admittedly somewhat limited in VBA, that they bring.

To the rescue:

MSHTML, gratias IE, offers a number of scripting object interfaces . One of which is the IHTMLDOMChildrenCollection interface, which inherits from IDispatch, and which:

provides methods to access items in the collection.

This includes the .Length property and access to items via .item(index).

on MacOS Big Sur 11.3.1 Apple Mail Version 14.0 (3654.80.0.2.43)

everything works fine, so maybe it's an old version problem?

Before you "unlock" the file from iCloud, you need to call startAccessingSecurityScopedResource to makes the resource pointed to by a security-scoped URL available to the app. And then don't forget to call the stopAccessingSecurityScopedResource.

You can also create a new boolean key LSSupportsOpeningDocumentsInPlace in the Info.plist file. If set it to true, the url will point to the file in iCloud but it hasn't be downloaded. So you can't access the file. If set it to false, it will makes a copy of the file in the Application Sandbox.