Access excel worksheet via color code

[GunjanDhawan]

Hi, There was a business requirement where I had to access the Excel Worksheet using color codes instead of Sheet Names..like do some X task for Red Color Sheets & Y task for Yellow Color Sheets. Had sheet names too, but didn't had to pick the sheets with that. Since it had to be done & BP didn't have support for this..i have achieved it via Excel Macros. Anyone having such a requirement in future can easily use it. Attached doc file is the Scenario, User guide & Solution for the same.   P.S. Would love to be see this being added as a Product Enhancement.

[AndreyKudinov]

Or just create a customised VBO Get Worksheet Names action to either output color codes along with sheet names or only return sheets with specific color. I can create a quick proof of concept later if you are interested.

[GunjanDhawan]

Thanks @aikudino Will surely consider this approach too next time !