Macro to save all sheet(s) in the active drawing as PDF except for the last sheet. Macro would prompt you to select a folder.
Please backup your data before using the macro.
The macro is made in SW2018 version but should work on lower version also. In case you're running a different version then update/correct the macro reference as suggested here (don't worry on the fact that video is for fixing missing library error but check the process to update your macro library): Fix-Update SOLIDWORKS Macro References
Thanks Deepak Gupta