Range.ConvertToLinkedDataType (Excel)

Attempts to convert all the cells in the range to a Linked data type such as Stocks or Geography.

The method will fail and throw a runtime exception 1004 if the specified locale is not supported on the specified service. It will have no effect (and throw no exception) in these cases:

ConvertToLinkedDataType (ServiceID, LanguageCulture)

Range("E5").ConvertToLinkedDataType ServiceID:=268435456, LanguageCulture:= "en-US"

Arguments

The following arguments are required:

ServiceID (Long) - The ID of the service that will provide the linked entity.

LanguageCulture (String) - A string representing the LCID of the language and culture that you would like to use for the linked entity.