importing latest version of a file

[Gti182]

Hello,

I'm having trouble with the filepath of a saved file i wish to import (example of the file name format below). The import file will always be named "DATA" then date then time report was run. I need to import the last report run within specific month folder.

K:\2011\02 Feb\DATA_20110203_1644.xls

Code i'd use to import the specific file:

Please Login or Register  to view this content.

[pike]

Hi Gti182

you can modify leiths code herehttp://www.excelforum.com/excel-prog...-a-folder.html

[Gti182]

thanks pike, had a long look and a bit of a play around but i'm not sure that i'm on the level to tailor his code to my situation. Could anybody else maybe suggest simpler?

[Gti182]

up please

[Gti182]

friday bump! Please boffins need help on this in a big way!

[pike]

try....

Please Login or Register  to view this content.

[pike]

ops you will need to change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and the pattern to

Please Login or Register  to view this content.

[Gti182]

Thanks Pike, I applied the macro and it ran through all the code but nothing happned? Did i apply the "Call Macro" function correctly?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[pike]

Hi Gti182

what happen with?

Please Login or Register  to view this content.

[Gti182]

Hi Gti182

what happen with?

Please Login or Register  to view this content.

getting a compile error: Invalid or unqualified reference on the bold text above.

Im thinking i should throw in the towel on this one

[pike]

does this open the lastest file?

Please Login or Register  to view this content.

[Gti182]

get a new error now

run-time error '438':
Object doesnt support this property or method

on line

Please Login or Register  to view this content.

[pike]

hmm. did check the code but

Please Login or Register  to view this content.

[pike]

More checking ...Try this to open the last modified or saved "DATA ???? .xls" in the folder

Please Login or Register  to view this content.