VBcode, send worksheet to printer before Excel exit

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Lloydm
    New Member
    • Feb 2007
    • 22

    VBcode, send worksheet to printer before Excel exit

    I built a timesheet and finally got all my functions working.
    Iv'e searched through the vb forum but had no luck finding a "print job" script. After saving file and before exit, I would like a script to prompt before exiting Excel to send the job to a printer. If user selects yes then print dialog window shows to select printer, if not do nothing and exit excel. Thanks to all, await a reply
  • willakawill
    Top Contributor
    • Oct 2006
    • 1646

    #2
    Hi. A script eh?
    Do you mean a way to code this in vba (excel)?

    Comment

    • Lloydm
      New Member
      • Feb 2007
      • 22

      #3
      yes, sorry for getting back to u this late

      Comment

      • Lloydm
        New Member
        • Feb 2007
        • 22

        #4
        u can find a sample of the time sheet on my storage space
        here's the link

        http://www.box.net/public/q270apbnxg#main

        Comment

        Working...