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