Data Reporting of Supply Chain Management - MS Execl
1. VBA CODE to Convert selected data into pdf
Public Sub PDF()
Dim saveLocation As String
saveLocation = "C:\Users\admin\Documents\myPDFFile.pdf"
Selection.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=saveLocation
End Sub
2. Check Spelling Mistakes in the workbook using VBA Code
Public Sub SpellCheck()
For Each wks In ActiveWorkbook.Worksheets
wks.CheckSpelling
Next wks
End Sub
3. https://drive.google.com/drive/folders/1derRFXZ_d2MF6Yl2QgScxVH9nqbK7RWF?usp=share_link