+ Reply to Thread
Results 1 to 1 of 1

macro to open most recently modified .CSV file

  1. #1
    Registered User
    Join Date
    05-12-2016
    Location
    Newcastle, England
    MS-Off Ver
    2010
    Posts
    10

    macro to open most recently modified .CSV file

    I wonder if anyone can help - i'm very new to macro's and was trying to improve one that i wrote a little while back.

    In essence its a little clunky but does the job where it basically filters to various criteria in a large source data workbook, and selects some info to copy into a new work book. Currently i have to have the source data file open to run the macro that extracts the data. I've been reading some online forums and 'borrowed' some code to build in opening the source data file to the beginning of the macro. The problem is its not working but because i've adapted someone else's code i don't really know what its doing to try and fix why its not working. The correct file does open but the formatting is off. Instead of all the dates showing as dd/mm/yyyy, dome dates seem to go to mm-dd-yyyy which throws the filters off and skews the rest of the data. Can anyone give me a pointer please. How would i open the .csv file without changing any of the formatting?
    Please Login or Register  to view this content.
    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
    Last edited by 6StringJazzer; 08-21-2016 at 08:09 PM.

+ 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: 2
    Last Post: 02-27-2014, 02:23 AM
  2. Replies: 10
    Last Post: 06-20-2013, 01:47 AM
  3. Reference cell data in most recently modified workbook in another directory
    By JSebastianRock in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2013, 11:14 AM
  4. Open the last modified file from sharepoint sites
    By vigneshwaran in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-14-2012, 12:25 AM
  5. Updating with the Most Recently Modified Workbook
    By cmajercz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-09-2012, 04:26 PM
  6. Import most recently modified text files
    By agentone in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2012, 06:00 AM
  7. Link or Open file by date modified
    By Burnsterboy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-20-2010, 11:16 AM
  8. Replies: 1
    Last Post: 03-14-2007, 12:18 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