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/1Vb-KKS73Z7VWQRknR7n8mKVQ_Int8cVq/view?usp=share_link

1 .Create VBA Code to convert selected data into pdf from applicant data

Sub Macro11()
'
' Macro11 Macro
' convert to pdf
'

'
ChDir "C:\Users\katta pavan reddy\OneDrive\Desktop\excel vydik"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\katta pavan reddy\OneDrive\Desktop\excel vydik\About Applicant Data.pdf" _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=True
Range("E5").Select
End Sub

2.Check Spelling mistakes in the workbook using VBA Code

Private Sub Workbook_BeforeClose(Cancel As Boolean)

Sheet1.Cells.CheckSpelling

End Sub