kakac

[KAKAC]

I have a file sent to a folder at end of month is it possible to pick this up and open it via a macro bearing in mind the file name changes for example last weeks file name was Jan05 next month Feb05. I also want to download the file into excel in the following format

Account Num Account Name Jan Feb (diffenent b/w the month % increase (decreese) Feb Mar diffenent b/w the month % increase (decreese) and so on

Thanks

 

[KAKAC]

Any help on this?

Thanks