PC Review


Reply
Thread Tools Rate Thread

[cell value from filename]

 
 
Karol_tom
Guest
Posts: n/a
 
      28th Jul 2010
Hi,

I have many files in one folder.
I need to choose using VBA one of them (specific text at the end of their
filename) and get three characters from
it to enter this to cell.

 
Reply With Quote
 
 
 
 
Don Guillett Excel MVP
Guest
Posts: n/a
 
      29th Jul 2010
On Jul 28, 4:33*pm, "Karol_tom" <Karol_...@wp.pl> wrote:
> Hi,
>
> I have many files in one folder.
> I need to choose using VBA one of them (specific text at the end of their
> filename) and get three characters from
> it to enter this to cell.


You don't explain very well. Try again, or.
"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell("filename") doesn't update to new filename when do save as. =?Utf-8?B?TG91aXM=?= Microsoft Excel Worksheet Functions 2 22nd Mar 2007 07:27 PM
Add filename in a cell =?Utf-8?B?RnJlZGRpZVA=?= Microsoft Excel Misc 3 22nd Nov 2006 03:04 PM
substitute the filename in a cell reference with a string in another cell. flummi Microsoft Excel Misc 11 22nd Feb 2006 01:14 PM
Cell To Be Filename Dan_Crew Microsoft Excel Misc 6 23rd Apr 2004 04:14 AM
Re: Using the Filename in a cell Mathew P Bennett Microsoft Excel Misc 0 19th Sep 2003 06:49 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:59 AM.