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

Q3.2)

Sub SaveSelectionAsPDF()

Create and assign variables

Dim saveLocation As String

saveLocation = "C:\Users\marks\OneDrive\Documents\myPDFFile.pdf"

'Save selection as PDF

Selection.ExportAsFixedFormat Type:=xlTypePDF, _

Filename:=saveLocation

End Sub

Q3.3) VBA CODE TO CHECK SPELLING MISTAKES IN THE WORKBOOK

Sub Highlight_Misspelled_Words()
Dim cell As Range
For Each cell In ActiveSheet.UsedRange
If Not Application.CheckSpelling(Word:=cell.Text) Then cell.Interior.ColorIndex = 6
Next
End Sub

------------------------------------------link of the attachment-----------------------------------------

https://docs.google.com/spreadsheets/d/1WU1qaG5UiT7oassdISC7BoTXJl0L75tR/edit?usp=share_link&ouid=108460639138757648802&rtpof=true&sd=true