Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

https://drive.google.com/file/d/1cjUMxeSYLWNcqVzIzaVokrKemJBYi8qG/view?usp=sharing

• Create VBA Code to convert selected data into pdf from applicant data

Public Sub convertPdf()
Dim wb As Workbook
Dim ws As Worksheet
Dim Rng As Range
Dim path As String
Dim fname As String

Set wb = ThisWorkbook
Set ws = wb.Worksheets("Applicant Data")
Set Rng = ws.Range("A1:DR307512")
path = "C:\Users\P SANJAY\OneDrive\Documents\"
fname = ws.Range("D23").Value & ".pdf"

Rng.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=path & fname, _
IgnorePrintAreas:=True
End Sub

• Check Spelling mistakes in the workbook using VBA Code

Public Sub SpellCheck()
Dim Rng As Range
For Each Rng In ActiveSheet.UsedRange
If Not Application.CheckSpelling(Rng.Text) Then
Rng.Interior.Color = RGB(255, 0, 0)
End If
Next Rng
End Sub