+ Reply to Thread
Results 1 to 4 of 4

Open specific excel file and log file information

  1. #1
    Registered User
    Join Date
    10-29-2012
    Location
    shrewsbury
    MS-Off Ver
    Excel 2003
    Posts
    25

    Open specific excel file and log file information

    Hi All I was wondering if somebody would be able to help me.

    I am looking for a way of creating a file which will tracker/log the date of a file change location and the username who carried out this change. Basically the document I am tracking will be template which people will fill out, dependant on info they fill in this can be rejected or accepted or pending and will go into specific folders on a network dependant on the status. I would also like to hyperlink the file in the location section in the tracker/log file.

    My question is it possible to do this with an excel file which opens in the background and updates then closes even though it is a template and how would you do it. I have attached the log file for your perusal

    Thanks in advance

    Chidi
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Open specific excel file and log file information

    Hello chidmas,

    Are you wanting to track the date of a file change, location, and the username of the template or the file the template has created?

  3. #3
    Forum Contributor
    Join Date
    04-24-2007
    Location
    NYC
    MS-Off Ver
    2k3/2k7/2010
    Posts
    270

    Re: Open specific excel file and log file information

    You can try using the workbook's .BuiltinDocumentProperties to pull out who and when saved the workbook.

  4. #4
    Registered User
    Join Date
    10-29-2012
    Location
    shrewsbury
    MS-Off Ver
    Excel 2003
    Posts
    25

    Re: Open specific excel file and log file information

    Sorry Leith Ross this is for the file the template creates

+ 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. Replies: 4
    Last Post: 10-23-2013, 12:54 AM
  2. [SOLVED] open variably named file, copy/paste data into consolidation file, open next file in list
    By sllawrence1968 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2012, 09:49 PM
  3. Creating a .txt file extracting information from a Excel file saving as .resx file
    By AbdallahHajbed in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-19-2012, 09:00 AM
  4. VBA for excel 2003. Open file dialog box, open 2007 file xlsx, continue with code
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2011, 12:12 AM
  5. To get information if an other Excel file is open
    By Sahak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2006, 04:03 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