Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
Create VBA Code to convert selected data into pdf from applicant data
Sub SaveActiveSheetsAsPDF()
Dim saveLocation As String
saveLocation = "Offical(D):\VithyaSathieswaran\Skill Lync\myPDFFile.pdf"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=saveLocation
End Sub
Check Spelling mistakes in the workbook using VBA Code
Sub SpellingMistake()
ActiveSheet.Checkspelling
End Sub
Drive Link
https://docs.google.com/spreadsheets/d/1cKk4N9XQB6l2lVuw4qsR9inL2AWtHIYb/edit?usp=sharing&ouid=102644380287955734170&rtpof=true&sd=true