Hi All

Wondering if someone can help me as I am pulling out what is left of my hair.

I am creating a excel file where the user will click the button to locate the latest file they need to check, open it and then the first part is it will pull in the required date, before it moves on later on.

However, I am getting an error on 400, so I am wondering if there is a memory leak in my code that I can't see? The file size for the template is only at 319kb - the file that I am currently opening to pull 1 sheet out of is larger at 10,844KB, however the error can appear before it even opens. This is my code at the moment:

Please Login or Register  to view this content.
The first parts where I have had errors is:

Please Login or Register  to view this content.
and if I take this out, it errors at here instead:

Please Login or Register  to view this content.
The problem I have, because the data in the other sheet is formulated, I need to paste as values, so on it's own

Please Login or Register  to view this content.
wont work, because I need the values paste.

Is anyone able to assist with this at all?

Thanks in advance.