stevenjobs
New Member
- Joined
- May 31, 2017
- Messages
- 6
Hi,
My macro displays an image of a product next to the the product's name on the pivot table. It does this by going into an directory where all the products' images are stored. This, however, takes a lengthy amount of time given the number of products. So, I split the directory into many subfolders, each folder is named after what kind of product it is (apparel, personal care, accessory, etc). There is a filter on the pivot table that filters all of these products into these sub categories as well.
Is there a way for me to get the String value of the active filter being used so that I can use this string to know what directory to search in for the product? I've struggled with .PivotField and the items properties for a long time now.
Any help would be much appreciated.
My macro displays an image of a product next to the the product's name on the pivot table. It does this by going into an directory where all the products' images are stored. This, however, takes a lengthy amount of time given the number of products. So, I split the directory into many subfolders, each folder is named after what kind of product it is (apparel, personal care, accessory, etc). There is a filter on the pivot table that filters all of these products into these sub categories as well.
Is there a way for me to get the String value of the active filter being used so that I can use this string to know what directory to search in for the product? I've struggled with .PivotField and the items properties for a long time now.
Any help would be much appreciated.
