Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
VBA Code to convert selected data into pdf from applicant data
Sub SaveAsPDF()
Dim WS As Worksheet
Dim FileName As String
Dim FilePath As String
Set WS = ActiveSheet
FileName = "Result PDF"
WS.PageSetup.Orientation = xlPortrait
FilePath = ThisWorkbook.Path
WS.ExportAsFixedFormat Type
MsgBox "Completed", vbInformation, ""
End Sub
Check Spelling mistakes in the workbook using VBA Code
Sub spellingmistakes_fromworkbook()
Dim myRange As Range
Dim myCell As Range
Dim rc As String
Set myRange=Activeworkbook
For Each myCell in myRange
rc=InputBox(Character(s) to check spelling mistakes","Enter Value")
For Each Range in workbook
If workbook Function. Countif(myRange , myCell,Value)>1Then
myCell.Interior.ColorIndex=38
End If|
Next
End Sub