Access Permission

[monika_vasvani]

Hi All I have one application in Visual Basic.I have created one folder at runtime.I want to give permission to that folder that only administrator can access this folder,nobody can. Is it possible in visual basic? Second problem is:I have created runtime excel files.It works perfectly. But problem is i want set allignment property through coding in excel file. My code is: Set AppXls = CreateObject("Excel.Application") Set ObjWb = AppXls.Workbooks.Add Set ObjWs = ObjWb.Worksheets.Add ObjWs.Range("B1").Value = "SISTER NIVEDITA SCHOOL ON WHEELS" ObjWs.Range("B2").Value = "SUPPORTED BY" 'ObjWs.Range("B2").Font.Bold = True ObjWs.Range("B3").Value = "SHARE AND CARE FOUNDATION-U.S.A" ObjWs.Range("B4").Value = "MEDICAL REPORT" ObjWs.Range("C4").Value = Label3.Caption ObjWs.Range("D4").Value = txt_date.Text ObjWs.Range("B7") = Text1(0).Text ObjWs.Range("B8") = cmb_address.Text ObjWs.Range("B9") = Text1(2).Text what i do? Pls help me. Thanks monika

[Khatri Mitesh]

Hiii Monika for the alignment in excel use the following

objws.Columns(1).HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter

May this solved your problem Thanx ~Khatri mitesh khatrimitesh@hotmail.com

[Lost User]

How to set folder permissions with VBScript[^]