Re: $$Excel-Macros$$ Formula to extract parent folder, parent of parent folder etc

2011-05-27 Thread STDEV(i)
try this formula =*SUBSTITUTE(B3* ,MID(B3,1+FIND("^",SUBSTITUTE(B3,"\","^",LEN(B3)-LEN(SUBSTITUTE(B3,"\",""-1,999),"") and see the attachment if it helps On Fri, May 27, 2011 at 12:56 PM, Jhoomla wrote: > Does any one have a function or formula to extract for a path for > eg., > > E:\02 M

Re: $$Excel-Macros$$ MAC Address

2011-05-27 Thread Mahesh parab
Hi Rajesh Try: Sub test() Dim strComputer As String Dim objWMIService As Object Dim colAdapters As Object Dim objAdapter As Object strComputer = "." Set objWMIService = GetObject _ ("winmgmts:" & "!\\" & strComputer & "\root\cimv2") Set colAdapters = objWMIService.ExecQuery _ ("Select * from Win32_

$$Excel-Macros$$ Time Issue

2011-05-27 Thread Chandra Shekar
Hi, I need to check whether date and time is greater than current date and time. Please find attached file. If date and time both are blank then it should check with present time and date. Thanks, Chandra Shekar B -- -

$$Excel-Macros$$ MAC Address

2011-05-27 Thread Rajesh K R
Hi Experts Is there any code to get MAC address of the computer. Regards Rajesh kainikkara -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldai

RE: $$Excel-Macros$$ Formula to extract parent folder, parent of parent folder etc

2011-05-27 Thread Daniel
Better : Parent folder : =MID(A1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT("1:"& LEN(A1))),3)+1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIREC T("1:"&LEN(A1))),2)-LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(IN DIRECT("1:"&LEN(A1))),3)-1) Parent parent f

RE: $$Excel-Macros$$ Formula to extract parent folder, parent of parent folder etc

2011-05-27 Thread Daniel
Assuming path is in A1 : Folder : =MID(A1,LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT("1:"& LEN(A1))),2)+1,MAX((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRECT( "1:"&LEN(A1-LARGE((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="\")*ROW(INDIRE CT("1:"&LEN(A1))),2)-1) Parent fol

Re: $$Excel-Macros$$ Dates in Excel

2011-05-27 Thread hanumant shinde
Just replace the year from 2011 to 2010. by using replace all - Original Message > From: Rich Prince > To: MS EXCEL AND VBA MACROS > Sent: Thu, 26 May, 2011 6:49:10 PM > Subject: $$Excel-Macros$$ Dates in Excel > > I have a column of various dates that have the incorrect year, for >

Re: $$Excel-Macros$$ Re: Urgent:: Is there a way out to increase the cell character limit to beyond 255.

2011-05-27 Thread Sixthsense
Hi Bharghav, This problem will occur when you perform the sheet *Move or Copy *option. My suggestion is just press Cntrl+A twice, which will select all data in your active worksheet and press Cntrl+C (to copy) and in New Worksheet Press Cntrl+A and Press Cntrl+V (to paste). In this case the data

$$Excel-Macros$$ Highlight previous revision Cells after new entry of New Revision

2011-05-27 Thread Rohan Young
Dear Experts & Ashish Ji, This is the status of Drawing, when we received the next revision of drawing (i.e.  we receive R1 after Ro), i need , when i enter the next revision the last revision  cells  should  be green highlighted, so i can understand this drawing goes superceded, here is another c

$$Excel-Macros$$ Formula to extract parent folder, parent of parent folder etc

2011-05-27 Thread Jhoomla
Does any one have a function or formula to extract for a path for eg., E:\02 My Documents\20 Ebooks and Articles\10.04 Tintin\01 Tintin in the Land of the Soviets.pdf Parent Folder: = 10.04 Tintin Parent.Parent.folder = 20 Ebooks and Articles Parent.Parent.Parent.Folder= 02 My Documents any hel