hi, I need help in a code to open a web page with vba code and on that page I have the org chart of my team. Each managers team is collapsed under him and each time I have to click the + sign to expand all managers team names. I need a code to expand all + signs automatically and then copy all the staff names listed on that page onto a excel worksheet. This is almost a everyday activity and consumes a lot of time doing it manually.
Any help on this is appreciated !!
