Could you please describe you approach with more details?
This thread may be helpful: https://vcampus.osisoft.com/discussion_hall/add_in_microsoft_development/f/11/t/2247.aspx
Make sure you've added ProcessBook references (PI-ProcessBook Type Library and Symbol Library) to the Excel VBAProject.
Thank you for that thread. It looks useful. I'll need to experiment. I was interested in whether it would be possible to automate some repetitive tasks from Excel VBA. Currently diverted in other directions so it may be a while before I get a chance to revisit it.