Challenge

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

->for converting data into PDF

Sub ExportDataToPDF()

Dim ws As Worksheet

Dim rng As Range

Dim savePath As String

' Set the worksheet containing your data

Set ws = ThisWorkbook.Sheets("YourDataWorksheetName")

' Define the range of data to export

Set rng = ws.UsedRange ' Modify this as needed

' Specify the path to save the PDF

savePath = "C:\Path\To\Save\YourReport.pdf" ' Modify the path and filename

' Export the range to a PDF file

rng.ExportAsFixedFormat Type:=xlTypePDF, Filename:=savePath, Quality:=xlQualityStandard, DisplayFileAfterPublish:=False

MsgBox "Data has been successfully exported to PDF.", vbInformation

End Sub

->Spelling mistakes in WB using VBA

Sub SpellCheckWorkbook()

Dim ws As Worksheet

For Each ws In ThisWorkbook.Worksheets

ws.Activate

Cells.CheckSpelling

Next ws

End Sub

this is also the drive link.

Ship work like this
in your own course.