From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Shivam Shukla
Sent: Thursday, 27 May 2010 8:16 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to insert sheets name in cells
Hello Dear,
Have a look in attached macro
Hi Rahul,
is it possible to do the reverse?, Suppose i create a new sheet and
paste some data in it . Now i want to name this sheet with the
contents of a particular cell,
say, cell D15 is 'May 15- Action Points', I want to name my sheet as
this 'May 15- Action Points'
thanks
Sameer
On May 2
Hello Mahesh,
So u have all files in a folder and u want macro to create the
details...
xls name
date created...etc
if it is ok,then let me know perhapes i can help you on this
On Mon, May 24, 2010 at 3:43 PM, Mahesh wrote:
> Dear All,
>
> I have around 200 xls files in a folder now i want
Mahesh,
To Insert a Workbook Name, the Formula below formula will work
=MID(CELL("filename"),FIND("[",CELL("filename"))
+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)
To insert the Sheet Name, the below formula will work:
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
To
