I figured out how to get all of the drawing properties to show up on an excel sheet using vba, but I just want to be able to select one property such as \\\$PRP:"SW-File Name" and have it go to a specific cell. Any help is greatly appreciated. Thanks

Set swCustPropMgr = swModel.Extension.CustomPropertyManager("")

vCustPropNames = swCustPropMgr.GetNames