Data import based on date & time filename

[james.goacher]

Hi everyone

Im looking for a little step in the right direction.
I need to setup an excel sheet that imports data from text files. The data is fixed width with some columns ignored. If the filename was the same i would just record a macro howver the filename is dependent on what date & time the user requires. Below is an example of the filename

fsc1_log2011100407

fsc1_log is a constant and the rest is yyyy mm dd hh. At the moment I have the fields ready for the user to select date and time but how do i go about automating the import process onto a new sheet?

Hope you guys can help
Cheers
James

 

[Joe4]

Welcome to the Board!

Why not just have the macro have them browse and select the file they want and then the macro will open it?
Take a look at Richard Schollar's code here: http://www.ozgrid.com/forum/showthread.php?t=71409

 

[james.goacher]

Thanks Joe4

However it needs to be as simple as possible and I know it sounds a bit mean but I showed someone the process and it blew their mind so thats the type of people that are using it. The way I have explained is layed out nice and neat and stress free for users not comfortable with computers and spreadsheets

I shall carry on searching & reading up

Cheers

 

[Joe4]

They people using it don't need to know the first thing about using VBA.

If you incorporate the code, all they have to do is click a button, and it will bring up a file browse window to the exact directory you want it to go to. All the user has to do is select the file they want (which, it sounds like will already have the date and time built into it), and the rest will be automated.

I don't see how that is any more complex than what you are asking for. Instead of asking the user to enter a date and time, they simply select the file with the date and time they want. It should actually by less keying, and remove the possibility of any typos.