Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
I am submitting the VBA Code here as discussed with the trainer for the last 2 question and as a link for the rest questions .
https://drive.google.com/drive/u/0/folders/1gVZ0tlYCXq5eJwHsoNMMj1nKdIg-WbcE
- Create VBA Code to convert selected data into pdf from applicant data
Sub ToPDE()
Dim wb As Workbook
Dim ws As Worksheet
Dim rng As Range
Dim FName As String
Set wb = ThisWorkbook
Set ws = wb. Worksheets ("Report Output")
Set rng = W.Range ("D3: J19")
FName = ws.Range ("M5") .Value & " " & Format (Now(),"MM-DD-YYYY") & ".pdf"
rng. ExportAsFixedFormat _
Type: =x1TypePDF, _
Filename : =Path & FName, _
IgnorePrintAreas:=True
- Check Spelling mistakes in the workbook using VBA Code
Sub highlightspellingmistake()
Dim rng As Range
For Each rng In ActiveSheet.UsedRange
If Not Application.CheckSpelling (word: =rng.Text) Then
rng.
End If
Next rng
End Sub