Challenge

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

Create VBA Code to convert selected data into pdf from applicant data

Sub SaveActiveSheetsAsPDF()
Dim saveLocation As String
saveLocation = "Offical(D):\VithyaSathieswaran\Skill Lync\myPDFFile.pdf"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=saveLocation
End Sub

Check Spelling mistakes in the workbook using VBA Code

Sub SpellingMistake()
ActiveSheet.Checkspelling
End Sub

Drive Link

https://docs.google.com/spreadsheets/d/1cKk4N9XQB6l2lVuw4qsR9inL2AWtHIYb/edit?usp=sharing&ouid=102644380287955734170&rtpof=true&sd=true

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.