This function retrieves information about published reports on the Web. In Excel it only exists as a placeholder. 

XL3ConnInfo( ConnectionID, ItemName, ShowCaption )

ParameterDescription
ConnectionIdReturns the number of connections to retrieve information.
ItemName

The name of the report property to retrieve in text format. Valid values are:

  • Server
  • Database
  • Cube
ShowCaptionFALSE returns the ID (default). TRUE returns the caption