Sir, do you have the opportunity to share your template? If you ask why, we want to do the same as you, but there are problems with the pages. I don't see the 1st page. You made the pages differently. Even though the codes are the same, it gives an error. On the formula page, it is on the 5th line for you, but for me it is on the 6th line. ...
How do I fix when i enter the code for product list button and try to run it, Run-time error '448': Named argument not found shows in my screen. Can you Help me with this problem?
Hi Dear Talat good day, I am trying to follow your coding to develop an inventory Management Software. On part three to display Product List in PDF format, receiving an error 1004......where I am using your advised codes Private Sub CommandButton8_Click() Sheets("Product List").Range("Plist").ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Users\Faizullahkhan\Documents\ExcelFolder\VBACoding\Test\Product List", _ includedocproperties:=True, ignoreprintareas:=False, openafterpublish:=True End Sub Can you please help me to fix the error and get product list displayed? Thanks in advance
@@excelautomation8883 I have already send an email to the given email address. I have attached xlsm file for your persual to find why receiving an error while trying to generat a product list in PDF file format.
Hi dear Mr. Talat good afternoon, today I have send one email to your goodself. You are requested to please read it. I am waiting for your reply with advice. Thanks
![Automated Invoice and Stock [ Inventory ] Management in Excel - Inventory Management in Excel](/img/n.gif)
Good work
Great job bro.
Sir, do you have the opportunity to share your template? If you ask why, we want to do the same as you, but there are problems with the pages. I don't see the 1st page. You made the pages differently. Even though the codes are the same, it gives an error. On the formula page, it is on the 5th line for you, but for me it is on the 6th line. ...
It doesnt search numbers?
How do I fix when i enter the code for product list button and try to run it, Run-time error '448': Named argument not found shows in my screen. Can you Help me with this problem?
Make a folder and name it Test in D Drive and keep your excel file there
Excel Automation Thank You Very Much I really Appreciate your Reply. Now I can Move forward to the next part
I try to make this but some thing is missing .so please give the file i will try to make again
I am getting an application undefined or object defined error while clicking product list. Kindly help me resolve it.
Be sure that you have entered correct path in VBA coding. Recheck the code.
@@excelautomation8883 yes i have given correct path as per your demo vedio. but its not working
Hi Dear Talat good day,
I am trying to follow your coding to develop an inventory Management Software. On part three to display Product List in PDF format, receiving an error 1004......where I am using your advised codes
Private Sub CommandButton8_Click()
Sheets("Product List").Range("Plist").ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Users\Faizullahkhan\Documents\ExcelFolder\VBACoding\Test\Product List", _
includedocproperties:=True, ignoreprintareas:=False, openafterpublish:=True
End Sub
Can you please help me to fix the error and get product list displayed? Thanks in advance
Check following for possible error:-
1. Dynamic name range is created named Plist.
2. Sheet name is matched with code.
Thanks for watching.
@@excelautomation8883 can you please share your email, I can send the complete file for your kind perusal and support. Thanks in Advance.
talatfarooq5@gmail.com
@@excelautomation8883 I have already send an email to the given email address. I have attached xlsm file for your persual to find why receiving an error while trying to generat a product list in PDF file format.
No mail received.
Hi dear Mr. Talat good afternoon, today I have send one email to your goodself. You are requested to please read it. I am waiting for your reply with advice. Thanks
It doesnt search numbers?