Excel VBA Basics #31 Send Sheets Straight to Printer using PrintOut Method

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 ธ.ค. 2024

ความคิดเห็น • 26

  • @excelisfun
    @excelisfun 11 ปีที่แล้ว

    Thanks for all your amazing videos!

  • @AhmedMohamed-vm2ob
    @AhmedMohamed-vm2ob ปีที่แล้ว

    Can I create a button to print external pdf file on desktop or I can't?

  • @pr1nyc1
    @pr1nyc1 9 ปีที่แล้ว +1

    Hello Dan, thank you for your videos. I want to use this feature to print a worksheet to PDF, without having to change the printer selected to "Adobe PDF". Is there a way to do that using VBA?
    Thanks

  • @saroruipinoyofw2587
    @saroruipinoyofw2587 11 ปีที่แล้ว +2

    .... i want to share you can also press in the keyboard if you lock up.

  • @johnweidner6981
    @johnweidner6981 4 ปีที่แล้ว

    Can I create a VBA that you can print to certain printer? But also Print copies based off of a cell value

  • @vicsar
    @vicsar 11 ปีที่แล้ว +6

    Here is a sample for those of you who might be interested.
    Sub iActiveSheet_Print()
    ' First choose a printer
    Application.Dialogs(xlDialogPrinterSetup).Show
    ' Make final arrangements and setup
    ActiveSheet.PrintPreview
    ' Print like there is no tomorrow
    ActiveSheet.PrintOut
    End Sub

  • @BernadetteCalado
    @BernadetteCalado 10 ปีที่แล้ว

    awesome VBA trick.
    I use for several clients.
    It seems to fail on MAC-OS can you help?

  • @krn14242
    @krn14242 11 ปีที่แล้ว

    Good job, enjoyed all the troubleshooting. Nothing ever works perfect the first time and you show how to resolve stuff. Hope you get the printer working. Funny, where did you get the print out idea? Hmmm? :)

  • @ExcelVbaIsFun
    @ExcelVbaIsFun  11 ปีที่แล้ว +1

    Victor, thank you!! Great tips! Dan

  • @yusufsmile9770
    @yusufsmile9770 9 ปีที่แล้ว

    Thanks for the lesson...you make it easy to understand...

  • @ExcelVbaIsFun
    @ExcelVbaIsFun  11 ปีที่แล้ว +1

    Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

  • @ObuL83g
    @ObuL83g 8 ปีที่แล้ว

    That's a nice piece of code you got there! Problem is, I lose comma decimal separator after .PrintOut Preview.=TrueWhen i set to False, everything is Ok. After nearly 3 years still searching for solution, and solution isn't Application.UseSystemSeparators=False ....

  • @dereklauder7
    @dereklauder7 3 ปีที่แล้ว

    Ctrl break will drop the macro

  • @saroruipinoyofw2587
    @saroruipinoyofw2587 11 ปีที่แล้ว +1

    instead of going in the task manager and ending the application... in this way you will not loose unsave file.

  • @wayneaskey
    @wayneaskey 10 ปีที่แล้ว +1

    Super videos, so very useful, thanks

  • @ChristophKleine
    @ChristophKleine 8 ปีที่แล้ว +3

    Am I the only who was freaked out by the use of "Sheet1.Printout. .." instead of the declared "ssheet"? :)

  • @mohitprasad3352
    @mohitprasad3352 ปีที่แล้ว

    Thansks

  • @janeiro301
    @janeiro301 5 หลายเดือนก่อน

    ward print buttom excel

  • @sharrongavin
    @sharrongavin 9 ปีที่แล้ว +3

    Dam that was a mess !!!

  • @FanoelGutierrez
    @FanoelGutierrez 10 ปีที่แล้ว +1

    Hey Dan, thanks for the Great Videos. I did the same think you're doing in this video. and I don't have problems with the code. my code read has follow:
    Private Sub CommandButton4_Click()
    Dim r As Integer
    r = InputBox("Cuantas Copias desea ? ", "Cantidad")
    Sheet1.PrintOut copies:=r, preview:=True
    Sheet1.PrintOut
    End Sub
    that allows you to see the preview and once closed it prints the qty in store in the variable r
    the difference is I'm not using a form to do it
    have a nice day

    • @ExcelVbaIsFun
      @ExcelVbaIsFun  10 ปีที่แล้ว

      Fanoel Gutierrez Bueno! Muchas gracias por los comentarios!

  • @vicsar
    @vicsar 11 ปีที่แล้ว

    Any time :-)

  • @punit6490
    @punit6490 5 ปีที่แล้ว

    clumsy...