Challenge

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

"C:\Users\Arjun\OneDrive\Applicant Data(AutoRecovered).xlsx"

"C:\Users\Arjun\OneDrive\About Applicant Data.csv"

Not Able to attach the files.

Sub SaveActiveWorkbookAsPDF()

'Create and assign variables
Dim saveLocation As String
saveLocation = "C:\Users\marks\OneDrive\Documents\myPDFFile.pdf"

'Save active workbook as PDF
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=saveLocation

End Sub

Sub HighlightMisspellings()

Dim cell As Range
For Each cell In ActiveSheet.UsedRange

'Check the spelling and if it's wrong, then change the style to be Bad
If Not Application.CheckSpelling(word:=cell.Text) Then
cell.Style = "Bad"
End If

Next cell

End Sub

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.