Automatically generating excel file using template

Hi,

I have a macro (double click any cell of Column C - "Create PDF") which creates an invoice in pdf form using a template ("Invoice Template" sheet) and saves it in the destination folder mentioned in the code.

I want an addition to this code wherein if I double click any cell of Column D an Excel sheet for that invoice gets generated and gets saved in the destination folder.

Thanks in advance!

Please Login or Register  to view this content.

So what part of the code is not working?

Please Login or Register  to view this content.

will create a new workbook, with just the sheet. It becomes the active workbook, use a saveas code to save the active wb, then close it.

This additional code in the worksheet doubleClick event will do it.
You will have to edit it to fit your requirements.

Please Login or Register  to view this content.