I couldn't find much out there for information on the serviceids for linked data types so I thought I would post this. These are the serviceid's for the Excel linked data types. I created it as an enum so you reference it ServiceID.xxxxx. This way when you type serviceid with a period folowing it, it will display a list of the ids for you to select.
To use linked data types in VBA you would use the following statement:
Range.ConvertToLinkedDataType ServiceID:=268435456, LanguageCulture:="en-US".
To see what each linked data type provides please see this article by Microsoft.
As of this writing I believe the only LanguageCulture supported is "en-us".
This list is current as of 5/14/21. As other linked data types are added I will try to keep this updated.
Public Enum ServiceID Anatomy = 1911554304 Animals = 1374683392 Automatic = 268435712 Chemistry = 1073742080 Cities = 1107296512 Currencies = 268435462 Food = 1342177536 Geography = 536870912 Locations = 536871168 Medical = 1578106624 Movies = 1879047930 People = 1610612480 Plants = 504364800 Stocks = 268435456 Space = 805306624 Terrain = 1375731968 Universities = 536871218 Yoga = 838861056 End Enum