'Enable folder picker to choose where to save the file 'Record Current Workbook Folder Path AddressįileName = SaveName & '_' & SaveTime & '.pdf' SaveTime = Format(Now(), 'yyyy mm dd _ hhmm') Assign this value to the variable “Save Path.”ĭim SaveTime As String Dim SaveName As String Dim SavePath As String Dim FileName As String Dim FullPath As String Dim SelectFolder As Variant 'Set Variables On Error GoTo EH

Step 4: Now, we need to save the PDF file to the exact location of the workbook that we are working on. Then, we must set the time to the variable “SaveTime.” Step 3: To give the file a name, we need to record the current time, i.e., the time of running the code. Step 2: Now, set “Workbook” and “Worksheet” reference to variables “Ws” and “Wb.” Step 1: We must first Declare variables in VBA Declare Variables In VBA Variable declaration is necessary in VBA to define a variable for a specific data type so that it can hold values any variable that is not defined in VBA cannot hold values. The following are the steps to convert an Excel sheet to PDF using VBA code. read more to convert the Excel sheet as PDF.

Follow the below steps to create VBA code Steps To Create VBA Code VBA code refers to a set of instructions written by the user in the Visual Basic Applications programming language on a Visual Basic Editor (VBE) to perform a specific task. However, what if a button can produce a PDF file of the Excel spreadsheet? We can do this by using VBA coding.

Visual basic for excel pdf