hi all,
i need a command for saving the existing pdf file as to save new name based on the textbox value in userform and saving into specific path as pdf.
hi all,
i need a command for saving the existing pdf file as to save new name based on the textbox value in userform and saving into specific path as pdf.
You don't give enough information to give a complete answer. If you want to save the sheet as a pdf then try this.
ActveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=ThisWorkbook.Path & Me.TextBox1.Value & ".pdf", _ OpenAfterPublish:=True
Actually for my project I'm having a multiple pdf invoices so for that i have to select and rename that file..inspite of that i have to do the selection by using vba and based on path and file name i given in textbox it has to save in that folder.
Why do you need to change the names of files?
Because i will download from other link so it will get as 1,2,3....soon so i have to give out the name for all the invoices as particular name using textbox.
anyone having solution???
I'm not even sure if you can rename pdf files using VBA
ok ..thank u
Don’t have an account yet? Register yourself now and be a part of our community!