+ Reply to Thread
Results 1 to 2 of 2

Manage documents

  1. #1
    Forum Contributor
    Join Date
    11-21-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    190

    Manage documents

    Hi,

    I'd like to update latest documents in network folder. Managers send a document to me, then I post this in the network folder, so everyone who needs this can save or print out.

    I wonder I can do this with Excel.

    Most of documents are Words and Excels and I have A LOT of them.

    I was thinking about Access at first but some people don't have Access program in their computer.
    I am sure everyone has Excel!

    I want to explain a little about document to an employee who wonder what this document name means and updated date.

    I also have a button beside explain, so an employee who knows what it is just print out the document without opening it.

    So far, this is what I want to achieve.
    Is this possible with Excel?

    Thanks in advance.

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Manage documents

    The attached workbook should contain the functionality you're looking for. Adjust the path name in B1 as needed, and it should be ready to go. Whenever you run it, it will add any new document names that it finds (not already in the Documents sheet) to the end of column A. You just need to then add the description, date, etc. I don't take credit for the code that searches the folder for file names. I found it on the internet. Have fun!

    ManageDocs.xlsm
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Separating a documents worksheets into individual documents
    By CWinkler in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-30-2019, 07:22 PM
  2. convert all 97-2003 excel documents to macro enabled documents on server
    By viperisback in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-23-2013, 09:06 AM
  3. Date Last Modified of Hyperlinked Documents + Collaboration of Hyperlinked Documents
    By mr butter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-15-2010, 05:35 AM
  4. excel documents won't open from my documents folder
    By Paul1961 in forum Excel General
    Replies: 2
    Last Post: 01-15-2006, 01:35 PM
  5. [SOLVED] Excel Documents Don't Appear in My Recent Documents
    By Addi in forum Excel General
    Replies: 4
    Last Post: 07-24-2005, 05:05 PM

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