Question: how to convert multiple excel sheets to multiple pdf files vba?
Answer: Quit Excel if it is already open.
Choose File> Create PDF> Batch Create Multiple Files.
In the Batch Create Multiple Files window, click the Add Files button and choose whether you want to process individual files or Folders, Click OK.