Re: Find Code Needs Help

select the permissions column and do Data=>Text to Columns, Select
delimited in the first tab, then select space as the delimiter.

--
Regards,
Tom Ogilvy


"Ange" <aarens@xxxxxxxxxxx> wrote in message
news:1159576283.370526.15120@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a table with two columns (Directory & Permissions), however, the
Rights (read, full control, etc) are part of my Permissions data.
(example below)

Directory Permissions
\\UMP\DEP_AMBC\ RUP-AMBC-CLINICS (Read)
\\UMP\DEP_AMBC\ SDIR-UMMCU-AMBC_ADMI (Full Control)
\\UMP\DEP_AMBC\ADMIN\ RUP-AMBC-CLINICS (Read)
\\\DEP_AMBC\ADMIN\ SDIR-UMMCU-AMBC_ADMI (Read&Modify&Delete&Add)


What I need to do is pull the Rights (read, etc) out of the Permissions
cell and put it into the next column. I thought I would simplify this
and just find the cell containing the specific Right and have that
Right entered into the next column (I can use find/replace code to
replace that part with "" later) so here's what I tried:

Sub TestRights()

Dim Row As Integer

Range("B2").Select
Row = ActiveCell.Row

Do Until Cells(Row, 2).Value = ""
If Cells(Row, 2).Find("Full Control") Then
Cells(Row, 3).Value = "Full Control"
Else
Row = Row + 1
End If
Loop

End Sub


Problem here is that I cannot get my Find code to work. I tried an
expanded version of it also that contained What, After, LookIn, LookAt,
SearchOrder, SearchDirection, etc. but that did not work either. Does
anyone have any other ideas or could possibly help with my messed up
code. I don't care if it's pretty, I just want it to be simple so I
can modify it later if needed.

Thanks,
Ange



.

Relevant Pages

  • RE: Need help understanding file rights
    ... Access Control List and if set no further permissions are checked. ... > I'm having some trouble understanding how Windows server does file rights. ... > to their home directories only and still be able to backup the server. ...
    (microsoft.public.windows.server.general)
  • Find Code Needs Help
    ... Rights (read, full control, etc) are part of my Permissions data. ... What I need to do is pull the Rights ... SearchOrder, SearchDirection, etc. but that did not work either. ...
    (microsoft.public.excel.programming)
  • Re: No access
    ... Inherited rights" I would make the share permissions being Everyone - ... Shared Directory gets Sharing Permission of Everyone - Full Control ... and Then on the folders departmental directory, on Security tab, give ...
    (microsoft.public.windows.server.general)
  • SBS 2003 Folder Share Permissions / Rights
    ... I am trying to create a folder on my new SBS 2003 machine that all users can ... see and that contains sub folders which have different group rights. ... I have assigned the local User group Read/Change Permissions to the Apps ... Accounting Group and have also assigned full control Security rights for the ...
    (microsoft.public.windows.server.sbs)
  • Re: Prevent changes to Administrator password
    ... What I am trying to do is give Taz1972 some options to minimize the risk or make it harder for a lower-level DA to reset the password for the EA account. ... Restricted Admins group to mitigate against what you propose Deji. ... also need to make sure the DAs in question cannot elevate their rights to EA, ... > By adding the Deny Write Permissions ACE, ...
    (microsoft.public.windows.server.active_directory)