Create folder, excel file, pdf file, clear details macro

[cemartinho]

Hi all,

This is my first post after being following this forum from a distance

I started a small business and after a year I decided to automate some of my annoying daily tasks. Invoicing!

Basically I create a folder in my computer (which is linked with my Sky Drive) with the same name as my client. Then I save the invoice in excel format and also a copy in pdf inside the folder. Trouble is, I have between 4 to 7 clients every day, making more than 25 folders and files to create. (some can be repeat clients, in which I dont need to create a folder just the new files)

I would love to have a macro to create a folder (if not there yet), save the excel file in that folder, create a pdf in the same folder, then auto increase the invoice number and clear the data before going to the next invoice.

I hope I could explain what I'm trying desperately to archive. The code I came up with is a mix of some of the codes I found on the net
I have attached my invoice template below.
Code is:

Please Login or Register  to view this content.

Thank you in advance!

Generate_Invoice.xlsm

[cemartinho]

I forgot to mention that when I run the macro nothing shows on my screen. I would think that an error message would show if there is any wrong parameters?
Please, if anyone have an idea of what I've done wrong, it would be much appreciated!
Carlos