I'll have Excel files from a folder listed on spreadsheet in column A6 & down
Will have right click trigger in column B
Need VBA to Save Excel file to another folder as .PDF
Source path is in A3
Destination path in B3
Source full path is A3 & A in ActiveRow
Destination full path is B3 & A in ActiveRow, but as .PDF, not Excel
Excel in Source folder needs to be replaced with .PDF in Destination folder, i.e. don't need to keep Excel file