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

LINK for Excel workbook Projext 2 : https://docs.google.com/spreadsheets/d/1SIfSDOPndZX6suhFu4VdIsCfWrrkmMq2/edit?usp=drive_link&ouid=103127765520200897942&rtpof=true&sd=true

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

Sub ExportSelectedDataToPDF()
Dim rng As Range
Dim saveFilePath As String

Set rng = Selection

If rng Is Nothing Then
MsgBox "Please select the data to export.", vbExclamation
Exit Sub
End If

saveFilePath = "C:\Path\To\Save\YourPDF.pdf"

rng.ExportAsFixedFormat Type:=xlTypePDF, Filename:=saveFilePath, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True

MsgBox "Selected data has been exported to PDF.", vbInformation
End Sub

-Check Spelling mistakes in the workbook using VBA Code

Sub CheckSpelling()
Dim ws As Worksheet
Dim rng As Range
Dim cell As Range


For Each ws In ThisWorkbook.Worksheets
Set rng = ws.UsedRange
For Each cell In rng
If VarType(cell.Value) = vbString And Len(cell.Value) > 0 Then
If Not Application.CheckSpelling(word:=cell.Value) Then
' Highlight the cell with spelling mistake
cell.Interior.Color = RGB(255, 0, 0) ' Red color
End If
End If
Next cell
Next ws
MsgBox "Spelling check completed.", vbInformation
End Sub