How to modify these VBA codes to save excel sheet in excel format (.xlsx)?
I have added a button in excel sheet and now when I click that button it saves the sheet at specific path with specific name but in pdf format. I want to save this sheet simply in excel format (.xlsx). so Sub PDFActiveSheet2() Dim ws As Worksheet Dim strFile As String On Error GoTo errHandler … Read more