Home Creators Posts Import Register Favorites Logout

Downloads

Content

Hello Members!

In this week’s Feature, Fix, or Focus, we take last week’s Dynamic Invoice Designer training.

Here are the updates I made for this training:

· Delete Selected Item Row requested by Carlo Gunter

· Add Footer For Buyer & Seller's Signature requested by Neak Niporn

· Save As PDF added by Randy Austin

· Delete Page added by Randy Austin

· Add Non-Existing Items Via Userform requested by @SssvcreationsAu2015 (YouTube)

Please don’t forget to add your requests for your own Feature, Fix or Focus each week when I post a new video, right here on Patreon. Each week I will either add a new feature, fix a bug or an issue, or create another training with a special focus on any part, all based on your feedback and comments.

Files

Comments

Geoffrey Metz

I've been looking at many of your examples and I have a question. What if I have more than one customer with the same name? When loading an invoice, it will load up the first person with that name even if another was originally selected. I figure a client number would solve it but I don't know how to implement it. Any suggestions would be great.

Excel For Freelancers

Hi and thanks for the great question. On most applications I use a unique ID for every record, however it is still advisable to have a unique name for every customer. I hope this helps and thanks

Geoffrey Metz

Got around to trying to install the multipage pdf system. Works great if I have your file in a folder in my C drive. If I have it at top level on my D it wont write to the disk and states something about permissions. This is beyond me ... any suggestions before I redesign where all my business files go? Same issue even if I use your original download. How do I set the permissions so this will work?

Geoffrey Metz

Odd, as the older single page pdf code you wrote works fine with my excel file at top level on D. Maybe its the delete part that doesn't get permission?

Geoffrey Metz

Seems I need to have it in a folder on D or it wont work - I guess this is a common issue as I found info about it. News to me ... sorry to waste your time.

Geoffrey Metz

At least on my computer, the page wont quite fit within the pdf margins despite working fine printing to paper. Adding: <p>With ActiveSheet.PageSetup .PaperSize = xlPaperA4 .Orientation = xlPortrait .Zoom = False .FitToPagesWide = 1 .FitToPagesTall = 1 End With</p><p>Seems to fix this</p>

Excel For Freelancers

Hi Geoffrey, since there so many different paper, printers and printer settings it makes sense that you would want to make adjustments with VBA< as you did above, or in the manual settings. Nice work and well done. :)

Mamun Parvez

Hi, Mr.Randy Can you create a macro that save an excel sheet as pdf then send it as attachment using whatsapp? any help will be highly appreciated

Abdoul Rachid Mahamadou

Hello Mr.Randy Please can you help me on this issue of characters, like the chr(252) when I click the cell it disappears that’s normal but when I click again it doesn’t shows up it shows me another character like a square or an interrogation mark!

Excel For Freelancers

Hi Abdoul, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: http://bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.

Excel For Freelancers

Awesome thanks so much. Now I know who you are. Appreciate the great idea and suggestion and happy to implement it. The Save as PDF was the first time I have implemented that type of solution. Glad you like it. Much appreciated