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/drive/folders/1563ZOsKNH6zpYLbKGpWMFEaJblc2wUDB?usp=share_link

• Create VBA Code to convert selected data into pdf from applicant data
• Check Spelling mistakes in the workbook using VBA Code

Sub SaveActiveSheetsAsPDF()

'Create and assign variables
Dim saveLocation As String
saveLocation = "C:\Users\marks\OneDrive\Documents\myPDFFile.pdf"

'Save Active Sheet(s) as PDF
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=saveLocation

End Sub

• Check Spelling mistakes in the workbook using VBA Code

Sub SpellCheckInActiveSheet()
ActiveSheet.CheckSpelling
End Sub