Hi All,

I'm currently in the middle of a project that will go on for a couple of months, and each day i need to look up to the previous days file, which I have managed to do with formulas and then edit links.

The problem is, i need to open yesterdays file and the previous day to that otherwise the file always seems to crash. I was wondering if by implementing a Macro to edit the links it would make it less likely to crash?

I have extremely limited VBA knowledge and currently dont even have a basis to go from, but if the general consensus thinks that a VBA would help, then I will look to implement this, but would need some more assistance

Any help would be massively appreciated,

Cheers,
Craig.