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

Other Deliverables:

VBA answers:

Private Sub pdfconversion()
Dim c As Range
Set c = Application.InputBox("select a range", "select a range", , , , , , 8)
myfile = "C:\New folder" & "SelectedData" & ".pdf"
c.ExportAsFixedFormat xlTypePDF, myfile, Standard, , , , , openafterpublish:=True
End Sub

Public Sub spellingcheck()
Dim cell As Range
Dim Ws As Worksheet
For Each Ws In ThisWorkbook.Worksheets
For Each cell In Ws.UsedRange
Ws.CheckSpelling (cell.Text)
Next cell
Next
End Sub

LINK:

https://drive.google.com/file/d/1rtXXURFH746DzXIiR2RmqRjKNC7ZA32E/view?usp=share_link