cancel
Showing results for 
Search instead for 
Did you mean: 

Excel Operations in V5

Sri_Krishna_Cha
Level 5
Hi All-   I have a requirement of writing different set of collection details to different sheets of a workbook which I am doing by looping through the collection.    I am creating a new sheet everytime I am looping through the collection and hence there will be dynamic number of sheets int he workbook.   But these sheets are not formatted and I tried to apply the conditional formatting to all the sheets in the workbook through enabling macros but seems because of my group policies I cannot enable macros by default.   I also could see there is nothing like renaming of existing sheets from the Actions available for Excel VBO. Please can you advise how this was implemented in your projects?
1 REPLY 1

Sri_Krishna_Cha
Level 5
Can someone help?