print & save

  1. B

    excel vba save worksheet as pdf.

    I'm having issues with this code not saving my file. I get an error 1004. it worked before. does any one see any issues with this code? Option Explicit Sub SaveAsPDF() Dim strDir As String strDir = CreateObject("WScript.Shell").specialfolders("Desktop") & "\Daily Reports\" If...
  2. V

    Print invoice with fixed format in a sheet

    Hi, I've enclosed a file, It would be very helpful if some one can help me on this. In the enclosed file if the number of products to be billed is more than 8 in the then print area adjustment is becoming very difficult. I should print it in two or more pages now. Here header (from cell A1...
  3. H

    Print AND automatically send to file at same time

    I would like to send a pdf to a file at the same time as I print. The file name should stay the same and just add .pdf at the end. My reasoning is for printing bills for my business. I would like to be able to go back and see the actual bill I sent out. I have already added the code to allow me...
  4. J

    Create Macro w/button to Print,Save & reset form

    I have two sheets in a workbook sheet 1 (a finished polished invoice form) sheet 2.( a list 1-20 to enter all info) I enter all of my information on sheet 2 and it populates in sheet one on a designed form. I need a macro with a button that executes it that will be at the bottom of sheet 2. So...
  5. A

    Print & save

    i am creat a print & save button only & i have no knowledge to creat a vba in excel "save & print the invoice in PDF format with invoice no & customer name and save the invoice in d:/invoice folder/Anil kumar 0001. PDF (My invoice print area:-B4:H54),(invoice no :- F7 COLUM),(customer name:-...
  6. A

    print & save

    i am creat a print & save button save & print the invoice in PDF format with invoice no & customer name and save the invoice in d:/invoice folder/Anil kumar 0001.pdf I have a single excel sheet (invoice copy) which i want to print 3 copies The invoice in the first page to be printed should be...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top