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 for Spell check
Sub SpellCheckIn_ActiveSheet()
ActiveSheet.CheckSpelling
End Sub
VBA COde for converting into PDF.
Sub Save_pre_Selection()
Dim LocationSave As String
LocationSave = "C:\Users\DELL\OneDrive\Desktop\Deliverables"
Selection.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=LocationSave, OpenAfterPublish:=True
End Sub
https://drive.google.com/drive/folders/1-fHxpdpH6y2prAzlcW35n_9BXgU5XCMy?usp=sharing