What I have :
What I need :
If gone by the attached screenshot, it shall be : 4_subbby_173B16.pdf ; where 173B16 shall be the file number
Attachments
My Attempts:
For renaming the file, I tried using
.
But here, the new file name is to be generated by two inputs, namely, the user input (file number) & sr.number(from the existing excel sheet)
Pls Help. Thanks in advance
ICO
P.S: HOW TO UPLOAD/ATTACH FILES??? CANT SEE ANY
- Have a file name subbby.pdf in a folder
- Have an excel sheet (screenshot attached)
What I need :
- Having given the directory where this file is located, I want the VBA program to select that file;
- Then ask the user for a file number (see attached screenshot) : I presume this can be done by an input MsgBox
- Then rename this file as “Sr. Number_subbby_filenumber.pdf”
- Also populate the excel sheet with the new name
If gone by the attached screenshot, it shall be : 4_subbby_173B16.pdf ; where 173B16 shall be the file number
Attachments
- Screenshot of the table
- Excel sheet with the table
My Attempts:
For renaming the file, I tried using
Code:
[COLOR=#333333]NAME "old file name" as "new file name"[/COLOR]
But here, the new file name is to be generated by two inputs, namely, the user input (file number) & sr.number(from the existing excel sheet)
Pls Help. Thanks in advance
ICO
P.S: HOW TO UPLOAD/ATTACH FILES??? CANT SEE ANY