Locating a file and renaming it based on existing excel sheet data

[subbby]

What I have :

• 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

1. Screenshot of the table
2. Excel sheet with the table

My Attempts:
For renaming the file, I tried using

[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

 

[Andrew Poulsom]

To what cell does sr.number refer?

 

[RoryA]

Cross posted here.

 

[subbby]

I am unable to upload files so as to help you understand my query. However pls see the table below,

• Range A1:A15 are all serial number
• Column B has file name
• Column C has File number (to be given as input by user)
• Column D has the NEWLY GENERATED file name

P.S. All files are in different filepath

Sr. Numbers	File Name	File Number	Desired name
1 <tbody> </tbody>	Instruction Manual	1A1	1_Instruction Manual_1A1
2	Service Manual	14438	2_Service Manual_14438
3	Parts List	22155	3_Parts List_22155
4	Technical Specification	A21727	4_Technical Specification_A21727

<tbody>
</tbody>

 

[subbby]

@RoryA

M just looking for answers... Is it against board rules to post the same query in different forums?

 

[RoryA]

No, but it is common courtesy to provide links to your cross posts (as it says in our rules). Other sites may enforce this more stringently.

 

[subbby]

Sorry about it. Shall adhere to the rules. Just reading them one by one.

Thanks & Sorry again !

 

[subbby]

To what cell does sr.number refer?

Hello,

was hoping I could get some help from you.

• Range A1:A15 are all serial number
• Column B has file name
• Column C has File number (to be given as input by user)
• Column D has the NEWLY GENERATED file name