hello
can any body help me to find macro to save data are showed in listbox & textbox as pdf & xlsx ,please?
so I have data in sheet1 and the userform contains textbox1,2,3,4 and listbox1 . when search for data it will show data in all of the textboxes,listbox1 when save the files as PDF & XLSX . the files PDF should save into folder D:\REPORTS and the files XLSX should save into D:\REPORTS\INVOICES
when rename the files after savING should be based on textbox2 . the textbox2 contains like this (INV1000-2-4/022)
thanks.
can any body help me to find macro to save data are showed in listbox & textbox as pdf & xlsx ,please?
so I have data in sheet1 and the userform contains textbox1,2,3,4 and listbox1 . when search for data it will show data in all of the textboxes,listbox1 when save the files as PDF & XLSX . the files PDF should save into folder D:\REPORTS and the files XLSX should save into D:\REPORTS\INVOICES
when rename the files after savING should be based on textbox2 . the textbox2 contains like this (INV1000-2-4/022)
thanks.