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 CreatePDF()
ActiveSheet.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:="Sample Excel File Saved As PDF", _
Quality:=xlQualityStandard, _
IncludeDocProperties:=False, _
IgnorePrintAreas:=False, _
From:=1, _
To:=5, _
OpenAfterPublish:=True
End Sub

*Check Spelling mistakes in the workbook using VBA Code

Public Sub highlightspelmistake()
Dim cl As Range
ActiveSheet.UsedRange.Interior.Color = xlNone
For Each cl In ActiveSheet.UsedRange
If Not Application.CheckSpelling(word:=cl.Text) Then
cl.Interior.Color = vbRed
End If
Next cl
End Sub

Please check the google drive link below.

https://docs.google.com/spreadsheets/d/1ZUp1jcehO_KccT38qxcGrdiNILoM1Lz4/edit?usp=sharing&ouid=111290577908035795183&rtpof=true&sd=true

https://drive.google.com/file/d/1pEJ1y4LFCyrbnt95T_-RDBPo2OjfimfO/view?usp=sharing