+ Reply to Thread
Results 1 to 2 of 2

[Urgent] Getting NetWare Info for Owner of File into Excel 2003 via VBA [Long Post]

  1. #1
    Registered User
    Join Date
    11-18-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    [Urgent] Getting NetWare Info for Owner of File into Excel 2003 via VBA [Long Post]

    Hi.

    I've tried searching for this answer to my problem for the past 4 hours to no avail. I just can't wrap my head around it. Here's the problem...

    The boss was super impressed with what I did to the "Directory Listing.xls" file (found here on last post: http://www.ozgrid.com/forum/showthread.php?t=27369) and how I organized it for what we needed. But now they want an extra cell to show who is the owner of each individual file! I'm not a wizard, so I am in dire need of help. Here's what I've got so far:

    Note: This is different from what is linked to above.

    Please Login or Register  to view this content.
    Note that Cells(1, 10) say "Testing". This is the column where I'm trying to add each individual file's novell netware info owner. I've found some resources about how to do this, but I can't think of how the hell to apply them. BTW I do have permission to view who owns each file by right-clicking on it -> Properties -> NetWare Info Tab

    [see next post]

  2. #2
    Registered User
    Join Date
    11-18-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: [Urgent] Getting NetWare Info for Owner of File into Excel 2003 via VBA [Long Pos

    Sample Code from Novell (Self-Extracting Zip): http://developer.novell.com/wiki/ind...nded_file_info

    The file "Form1.frm" when viewed in a text editor (we don't seem to have real VB) contains what looks like lots of junk, but there is one thing that stands out:

    Please Login or Register  to view this content.
    I'm fairly certain that what I am looking for is what I've highlighted in bold.

    A small thread about it on Novell forums: http://forums.novell.com/novell-deve...le-rights.html

    Another thread without replies: http://www.mrexcel.com/forum/showthread.php?t=28803

    Please help! I just can't seem to figure out how to apply what I want (which is the ownerID) to each file in a seperate cell.

    PS: There's no way I'm going to manually add each file's owner for over 100,000 files! Help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1