Loading...

Video Aula 12 - Salvar planilha excel em PDF com VBA

42,376 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 6, 2013

link para baixar o suplemento para gerar PDF a partir do VBA http://www.microsoft.com/pt-br/downlo...


Veja em: http://youtu.be/HIRSmFO0V6Q Como criar área de impressão e guardar caminho do PDF para impressão...



Código da Macro:

Sub PDF()

Dim nome As String

nome = ThisWorkbook.Path & "\Recibo " & ActiveSheet.Range("i3").Value & " - " & ActiveSheet.Range("d5").Value & ".pdf"

ActiveSheet.Range("a1:l169").ExportAsFixedFormat Type:=xlTypePDF, Filename:=nome

End Sub

  • Category

  • License

    • Standard YouTube License

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...