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

drive link - https://docs.google.com/spreadsheets/d/1R0eSdMFZJnah1BfJRPzHMxGn1tXVITN3/edit?usp=share_link&ouid=105343265161383763456&rtpof=true&sd=true

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

Dim ws As Worksheet
Dim strPath As String
Dim myFile As Variant

Set ws = ActiveSheet

'enter name and select folder for file
' start in current workbook folder
strPath = ThisWorkbook.Path & "\" & ws.Name & ".pdf"
myFile = Application.GetSaveAsFilename _
(InitialFileName:=strPath, _
FileFilter:="PDF Files (*.pdf), *.pdf", _
Title:="Select Folder and FileName to save")

'export to PDF if a folder was selected
If myFile <> False Then
ws.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=myFile, _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=False
End If
End Sub

• Check Spelling mistakes in the workbook using VBA Code

Sub checkspelling()
Dim sp As Range
For Each sp In ActiveSheet.UsedRange
If Not Application.checkspelling(word:=sp.Text) Then
sp.Interior.Color = vbRed
End If
Next sp
End Sub