Hi everybody.
Is there a way to insert in the "text to display" only part of the filename as opposed to the entire filename? For Example if the filename is called "2014-02-20 order-no.465-Product.xlsm" I would like for the code to extract the number "465" and the word "Product" and display the text as "465 Product" on the selected cell.
Thanks in advance:-)
Please Login or Register to view this content.
do the formats of the file names change? Will it always be a 3 digit number and the word product?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Good question, the number will always have 6 digits but the word "product" was just an example because the product I am selling my customers will differ with each order. So I want that to be flexible.
Can this help?
Please Login or Register to view this content.
Hi, kosherboy,
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Thanks for your reply but can you please incorporate your code into my code code?
Also, please note that the file name is never consistent and the words in the filename don't always have the same amount of letters.
Hi, kosherboy,
Ciao,Please Login or Register to view this content.
Holger
Oh wow! That is amazing! Thanks!
Re: Macro to display part of filename in cell
Hi !
Originally Posted by kosherboy
If it's always the last two parts separated by "-" to extract and
if it's always a point before the number and a point after the name,
it's really easy whatever the characters' number!
Please Login or Register to view this content.
Hi, kosherboy,
not so amazing as the name of the workbook must start with the date like "yyyy-mm-dd" followed by a blank and "order-no." which make up the 20 characters that we want to omit. A bit more stable would be to search for "order-no." with InStr and add the number of characters of the start of the position of the search string.
Same goes for the extension: as long as you use the new files itīs okay, if you want to include the old format a well you should use InStrRev and search for the position of the last dot in the filename.
And really the last gimmick: number and product must be divided by a dash.
If all that is in the Name: no problem.
Ciao,
Holger
Hi HaHoBe,
have you read my previous post ?!
Hi, Marc,
there are a lot of different ways to solve a problem, I admit your way might be more elegant - but a) some minutes after mine and b) your sample isnīt incorporated into the original code as requested.
Ciao,So what?
Holger
I hear. So is there a way to always have the code search for the last two words in the filename? In this case the number "465" and the word "product"?
Re: Macro to display part of filename in cell
Yes, just test my previous code ‼
Another way to extract text based upon "order-no." :
Please Login or Register to view this content.
Last edited by Marc L; 02-20-2014 at 02:54 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks