hi Dave,
thanks for ur replay, well yes its very confusing, i have a file name
AXN which is having some data inside with column A, B, C, now there is
another file (or a sheet2 of AXN) with two column A, B which says
channel name and channel code and data in it is AXN and 234 and other
such
HI
so can u tell me how will u import file name in tha same sheet ... i
am doing +cell(filename) but this is giving whole path but i just
need file name...??
On May 31, 12:18 pm, robin_suv mail2rbhand...@gmail.com wrote:
hi Dave,
thanks for ur replay, well yes its very confusing, i have a
Hi Robin,
You can import the file name into any cell with the following formula:
=MID(CELL(Filename),SEARCH([,CELL(Filename),1)+1,LEN(CELL(Filename))-1-SEARCH(],CELL(Filename),1))
I'm sure that there's a shorter single-formula method, but I can't think of it
just now.
Waiting for your sample
Hi Robin,
I have tried to understand your needs, but cannot.
1. a macro which will read my file name
This we can do.
2. i want that my macto add a
column D and reads my saved file name and put a digit 25 in that D
coulmn in range d1 to d last (till column A, B, C, carries data) ??
This I