Need a command for saving the already used pdf file using textbox value

Baski007 · May 6th 2020

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.

**royUK** · May 6th 2020

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

Baski007 · May 6th 2020

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.

**royUK** · May 6th 2020

Why do you need to change the names of files?

Baski007 · May 6th 2020

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.

Baski007 · May 7th 2020

anyone having solution???

**royUK** · May 7th 2020

I'm not even sure if you can rename pdf files using VBA

Baski007 · May 7th 2020

ok ..thank u

Need a command for saving the already used pdf file using textbox value

Participate now!

Share

Tags