importing the newest file in a folder as text

Hi,

I need to import a csv file into excel as text. As this is the only way I can retain all the info in all the cells, ie opening it directly in excel results in missing data, dont ask me why.. I download this file daily. I'd like to design a macro that would perform this function for me, ie import the newest file in my downloads folder as a text file. Following that i have another macro I run on the data.

Thanks in advance!

HW

Thanks for that link.

What I am looking for is to import the latest file as text, rather than open it directly. I could probably use some of that code to find the most recent file, however i'm no expert in reading VBA code. Your help appreciated!

HW

Thanks for the previous messages on this thread. this thread is now unblocked so any furhter help would be appreciated.

Thanks,

HW

Pike,

Your code does open the latest file in the folder. Due to the characteristics of the file that I am opening however I lose data when I do it this way. In order to not lose data I use the Get External Data>From Text commands.

I probably wasn't clear enough in my first post. Does this make it clearer? Principally I'm looking for a macro to retrieve data from the latest file in a folder using the Get External Data command.

Thanks

Thanks JBeau for the encouragement.

This is the recording of the steps I use to get the data I want:

Please Login or Register  to view this content.

I'm a little unsure how to join this code to that supplied by Pike. I'm not particularly good at reading code but I guess the key is in the first couple of lines.

I think I'd start the code with the first part of Pikes macro:

Please Login or Register  to view this content.

But where would I insert:

Please Login or Register  to view this content.

?

Yep, I'm still beginning at this.

HW

Great, thanks for this. It works a dream. I just updated the date to 2011.

Will get this thread marked as solved.