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.