I had a macro created to print the quote, incremental increase and clear data. I did have it save as an excel document, but now we would like it to save as a PDF. This is what I have in my system.
Sub PrintSaveIncrementalInvoice()
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Dim NewFN As Variant
Sub SaveActiveWorkbookAsPDF()
Sub SaveFileWithMacro()
Dim Path As String
Dim fn As String
Path = "C:\Users\Teresa\anvilmachine.ca\Document Portal - Documents\Quotes\Quote & Range("G10").Value & ".PDF"
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=Path & fn & ".pdf"
Application.DisplayAlerts = True
ActiveWorkbook.Close
Range("G9").Value = Range("G9").Value + 1
'THIS CLEARS THE CELL RANGE, C13, G11, A18:I33, A36
[C12, A17:I40].ClearContents
End Sub
I'm not very good at Macros if anyone can help please!
Sub PrintSaveIncrementalInvoice()
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Dim NewFN As Variant
Sub SaveActiveWorkbookAsPDF()
Sub SaveFileWithMacro()
Dim Path As String
Dim fn As String
Path = "C:\Users\Teresa\anvilmachine.ca\Document Portal - Documents\Quotes\Quote & Range("G10").Value & ".PDF"
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=Path & fn & ".pdf"
Application.DisplayAlerts = True
ActiveWorkbook.Close
Range("G9").Value = Range("G9").Value + 1
'THIS CLEARS THE CELL RANGE, C13, G11, A18:I33, A36
[C12, A17:I40].ClearContents
End Sub
I'm not very good at Macros if anyone can help please!