Results 1 to 3 of 3

VBA to return date created

Threaded View

  1. #1
    Registered User
    Join Date
    07-26-2007
    Posts
    2

    VBA to return date created

    Hi,

    I found this code that copies the data from workbooks in a folder and pastes the data onto a master sheet. The code works fine but I also need to return the date the original workbooks were created(or the file name as it contains the date created) in each row of the master sheet containing data. Ideally the code would add a new column to the master sheet and place the date corresponding to the sheet the data was coppied from in each row. I have attatched the code below. Could someone please advise me on how to accomplish this.

    Thanks
    Attached Files Attached Files

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