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 PDF()
'
' PDF Macro
' PDF
'
' Keyboard Shortcut: Ctrl+Shift+P

Dim ID As String

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"D:\DATA SCIENCE\Myfile" + Myfile + ".pdf", _
IgnorePrintAreas:=False, OpenAfterPublish:= _
False

End Sub

• Check Spelling mistakes in the workbook using VBA Code

Public Sub SpellingMistakes()

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

Everything is perform in Microsoft 365, Click on the Google Drive Link

https://drive.google.com/drive/folders/1s8Qhn9P5WalUSYRDrw-JH0urWZm5eFdn?usp=sharing