Challenge

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

VBA Coding for Converting to PDF

Sub ConvertingintoPDF()

Dim rng As Range
Dim ws As Worksheet

Set ws = ThisWorkbook.Sheets("Applicant Data")
Set rng = ws.Range("a1:e11")

rng.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Users\Vinothan\Desktop\Deepika\" & "Excel\Project\" & "project 2.Pdf"

End Sub

VBA Code for Check spelling

Sub Check_spelling()

Dim cell As Range
For Each cell In ActiveSheet.UsedRange

If Not Application.CheckSpelling(word:=cell.Text) Then
cell.Style = "bad"
End If

Next cell

End Sub

PLEASE FIND BELOW THE ATTACHED LINK FOR THE ABOVE PROJECT

https://drive.google.com/drive/folders/1JaxG9WQxv69xvi3FmRtILMbNQVcfr5fe?usp=share_link

PLEASE FIND BELOW THE ATTACHED FILE OF PDF BY VBA CODE

Your portfolio, next

Ship work like this
in your own course.

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.