$$Excel-Macros$$ Re: read saved file name and put a digit in a column range ????

2009-05-31 Thread robin_suv
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 wrote: > hi Dave, > > thanks for ur replay, well yes its very confusing, i have a fi

$$Excel-Macros$$ Re: read saved file name and put a digit in a column range ????

2009-05-31 Thread robin_suv
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 channe

$$Excel-Macros$$ read saved file name and put a digit in a column range ????

2009-05-30 Thread robin_suv
hi friends, i am looking for a macro which will read my file name (saved file where i will run macro) and print a code in given range of a column, for an example if my file name is test (saved in desktop) is carring some data in column A, B, and C, i want that my macto add a column D and reads my

$$Excel-Macros$$ want macro help plz its urgent...

2009-05-29 Thread robin_suv
hi, i am looking for a macro code for a sheet named "test" (suppose), when i open test it run a macro which will save a new file test1 and add a column to test1 with code 22 in cell i1:i200 , is this can be done?? please help me on this... --~--~-~--~~~---~--~~ --