Invoice Creation Macro

**dhammdip17a** · 06-11-2013, 02:01 AM

Sample Invoice 1.xlsx

Hi,
My Name is dhammdip,
I wanted a macro which can create Invoices. as per the raw data.
as I attached sheet, i have a dumb data then it has to in the right place of the invoice as sheet2(invoice)
In sheet 2 (invoice) whatever is in black that not to be change only RED values has to be change.
And every invoice has to saved as a new excel file.
Please help me to do that.

**vaibhav2312** · 06-11-2013, 05:41 AM

Please find attached workbook.

Only way is
Change your red highlighted values & press button "Save in Raw Sheet"
Create "Invoices" folder on your "D" Drive ( one time only) & then press button "Save Excel Copy"

Please Login or Register  to view this content.

Hope this help

Regards
Vaibhav

**dhammdip17a** · 06-11-2013, 07:56 AM

Hi vaibhav,

Thank you so much for you help.
But this macro giving error
NewBook.SaveAs FileName:=FilePath & FileName

Please d check and revert

Thanks
Dhammdip

**vaibhav2312** · 06-11-2013, 08:04 AM

Please create folder "Invoices" on your D drive

**dhammdip17a** · 06-11-2013, 08:24 AM

Hi Vaibhav did it.
But still same issue

**dhammdip17a** · 06-11-2013, 08:25 AM

Hi Vaibhav did it.
But still same issue

**vaibhav2312** · 06-11-2013, 08:28 AM

Please check revised attachment

**dhammdip17a** · 06-13-2013, 12:22 AM

Hi Vaibhav,
Thanks,

But still same issue.

please check attached snap for your reference

and please do the needful.

One more request for you. no issue if the new excel file wasn't save with the order no. i can do that manually. but at list all the information has to be on there place.

Thank You.
Dhammdip