Writing a file’s name (or renaming it ) based on existing excel sheet data

**subbby** · 08-29-2012, 08:03 AM

What I have :

Have a file name subbby.pdf in a folder
Have an excel sheet (screenshot attached& excel sheet 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 or excel sheet) : 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

Please Login or Register  to view this content.

. 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)

Any help is most welcome. Thanks in advance

Cross Posted by me in :

**rvasquez** · 08-29-2012, 08:15 AM

Are the files all in the same filepath/folder?

**subbby** · 08-29-2012, 08:16 AM

rvasquez,

nope they are in different folders

subbby.pdf shall have a different file path and the existing excel sheet is on a different file path

Thanks.

**rvasquez** · 08-29-2012, 08:26 AM

Where will you be specifying where the document is located?

**romperstomper** · 08-29-2012, 08:28 AM

Cross posted here: http://www.mrexcel.com/forum/excel-q...heet-data.html

**subbby** · 08-29-2012, 08:33 AM

Any help in this regard will be highly appreciated.

I have been trying different codes but unable to figure out this one. M pretty new to VBA programming

**subbby** · 08-30-2012, 11:01 AM

Originally Posted by rvasquez

Where will you be specifying where the document is located?

Used this code I got from the net . This gives locates the file

Please Login or Register  to view this content.

**Cutter** · 08-30-2012, 07:15 PM

Thanks RS

Hello subbby, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

**subbby** · 08-30-2012, 08:11 PM

@ Cutter

Done ! Thanks ...

Hope someone helps !

Writing a file’s name (or renaming it ) based on existing excel sheet data

LinkBack

Thread Tools

Rate This Thread

Display

Writing a file’s name (or renaming it ) based on existing excel sheet data

Re: Writing a file’s name (or renaming it ) based on existing excel sheet data

Re: Writing a file’s name (or renaming it ) based on existing excel sheet data

Re: Writing a file’s name (or renaming it ) based on existing excel sheet data

Re: Writing a file’s name (or renaming it ) based on existing excel sheet data

Re: Writing a file’s name (or renaming it ) based on existing excel sheet data

Re: Writing a file’s name (or renaming it ) based on existing excel sheet data

Re: Writing a file’s name (or renaming it ) based on existing excel sheet data

Re: Writing a file’s name (or renaming it ) based on existing excel sheet data

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions