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 subfolder 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 filter option being used so that I can use this string to know what directory to search in? For example, if the filter on the pivot table is switched to "Apparel," what code would give me that String so I know to search for the image in the "Apparel" subfolder I have created. 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 subfolder 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 filter option being used so that I can use this string to know what directory to search in? For example, if the filter on the pivot table is switched to "Apparel," what code would give me that String so I know to search for the image in the "Apparel" subfolder I have created. I've struggled with .PivotField and the items properties for a long time now.
Any help would be much appreciated