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

https://docs.google.com/spreadsheets/d/1U5MJkzvFdSAjFXyXMb96PFaIblVWxPDp/edit?usp=share_link&ouid=104143705585879417445&rtpof=true&sd=true

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

• Sub PrintSelectionToPDF()
  'SUBROUTINE:PrintSelectionToPDF
  'DEVELOPER:Ryan Wells
  'DESCRIPTION:print your currently Selected range to a PDF

  Dim ThisRng As Range
  Dim strfile As String
  Dim myfile As Variant

  If Selection.Count = 1 Then
  Set ThisRng = Application.InputBox("Select a range", "Get Range", Type:=8)
  Else
  Set ThisRng = Selection
  End If
  'Prompt for Save location
  strfile = "Selection" & "_" _
  & Format(Now(), "yyyymmdd _ hhmmss") _
  & ".pdf"
  strfile = ThisWorkbook.Path & "/" & strfile

  myfile = Application.GetSaveAsFilename_

  End Sub

  • Check Spelling mistakes in the workbook using VBA Code

  Sub CheckSpelling()

  Dim ws As Worksheet

  For Each ws In ThisWorkbook.Worksheets
  ws.CheckSpelling
  Next ws

  End Sub