Macro that incrieas invoice +1, save as with information from two cells and clear out rows

[Hönsafötter]

Hi

I´m a total newbe in excel who has started to create an invoce. I´m "almost" done

The thing I`ve left is that i want a button who does this on click:

1) Save the new invoice as an PDF file in my documents folder "faktura 2014" (using a mac).
2) Increase the invoice number by 1, invoice number is in cell E5. Clear out cells A12-F30 + G5, in the excel file and saves it


Is this even possible? I have found out how you make a button and connect macros to it.

If anyone can help me with this it would be amazing!

//Andrea

[Hönsafötter]

I´ve almost solved the entire problem. The thing I´ve left is that I don´t know how to clear G5 and I need the macro to print Three copies.

Anyone who can help me?

//Andrea

[xlman]

Let's assume that your file name is stored in the string "FName"

Use this line to export your excel sheet to PDF format

' ThisWorkbook.ExportAsFixedFormat Type:=xlTypePDF, filename:=FName, _
Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False

For clearing data from G5 cell use this code
Range("G5") =""

For printing use code below:

Please Login or Register  to view this content.

Regards,
xlman