I have a large file around 200 sheets. Currently I use KuTools to pdf the sheets but it now crashes and I have to do a little bit at a time and cannot select the entire list.
Is it possible to write a code that would PDF all worksheets with the following naming standard 101254_Smith. The worksheets are separated by an underscore, the first set is the employee ID and the part after is the last name.
I am not sure why its crashing, perhaps its the add in but if possible I would like to try a different approach.
Take care all.
Bookmarks