+ Reply to Thread
Results 1 to 2 of 2

Input an Import file Datelastmodified info into specific location in destination workbook

  1. #1
    Registered User
    Join Date
    06-22-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Input an Import file Datelastmodified info into specific location in destination workbook

    Hi all,
    I am working on a script based on Ron de Bruin's "Copy every csv" original found here http://www.rondebruin.nl/win/s3/win022.htm
    I am only importing 1 csv and I would like to get its Datemodified date and time and input it into the destination workbook in a specific cell.
    I can do this if I hardwire the file path into my code but I cant get it to work using Rons code. I have tried using FileDateTime code and also a method using FileSystemObject. Both work separately when the path is fixed but not using Ron's file selection method.

    Working sub code as follows, I've commented out the FileSystemObject method:-
    Please Login or Register  to view this content.
    Here's Rons amended code:-

    Please Login or Register  to view this content.
    Any help gratefully received,
    Ian99
    Last edited by Ian99; 09-29-2013 at 01:30 PM.

  2. #2
    Registered User
    Join Date
    06-22-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Input an Import file Datelastmodified info into specific location in destination workb

    Hi All,

    Managed to solve this myself so here's the working code in case it helps anyone else. As you can see, I stripped it down so it can't accept multiple files but thats fine for my solution.
    Please Login or Register  to view this content.
    Kind Regards
    Ian99

+ 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. [SOLVED] Import several rows from one workbook to same destination in another wb
    By Ejb123erok in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2013, 11:03 AM
  2. Replies: 3
    Last Post: 07-11-2013, 03:01 AM
  3. How to move a workbook to a specific destination using VBA?
    By js1537 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-10-2013, 04:37 AM
  4. jump to hyperlink, extract value at specific destination in file
    By Philip in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. [SOLVED] jump to hyperlink, extract value at specific destination in file
    By Philip in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11: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