Re: $$Excel-Macros$$ MkDir (ThisWorkbook.Path & "\33")

;*GiveThecellReferenceHere"*) > > End Sub > > > On Fri, May 6, 2011 at 4:43 PM, rajan verma wrote: > >> Sub MkDir() >> Dim fso As New Scripting.FileSystemObject >> >> fso.CreateFolder (ThisWorkbook.Path & "\" & 33) >> >> End Sub >> &g

$$Excel-Macros$$ MkDir (ThisWorkbook.Path & "\33")

Hi I want to create one folder in the same folder... MkDir (ThisWorkbook.Path & "\33") this will create a folder with the name 33. I want to link the name with a cell so that if the value is 34 the created folder name will be 34. if the cell value is 38 the folder name should be 38. Pls help. T

$$Excel-Macros$$ VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0)

Folk I have different workbook with different name in different folder. the workbook name will be like SC231WK34, SC231WK35, SC231WK36 etc. all the sheet will be in the same format. is there any way to write vlookup where I can link the part of the name to any of cell. VLOOKUP(H17,[SC231WK34.xls]

$$Excel-Macros$$ excel 2003 or 2007???

Hi is there any code that will allow me to run the first macros if the user is excel 2003... and the second if the user is excel 2007. regards Pravin -- -- Some important links for excel users: 1. Follow us on TWITT

$$Excel-Macros$$ problem in if else function

Hi I am trying to write a code: I want to Call Test only if all the criteria fulfilled or else this should keep msging to get the details.. not able to finish it. Pls help. * * * * *Sub if_Save()* *If Sheet2.Range("M5") = "" Then* *MsgBox ("Please enter Name")* *ElseIf Sheet2.Range("M6") = "" Then

Re: $$Excel-Macros$$ Help required with if formula

use this formula in cell D7 =IF(OR(B7="A",B7="B"),IF(C7<=$C$4,$B$4,IF(C7<=$C$3,$B$3,IF(C7<=$C$2,$B$2,0))),IF(C7<=$E$4,$D$4,IF(C7<=$E$3,$D$3,IF(C7<=$E$2,$D$2,0 On 12 May 2010 12:31, lucky singh wrote: > Dear All, > > > Kindly help with the IF formula in the attached sheet asap. > > Thanks an