Hi all

Not sure if this has a general or VBA only solution, but I'll start here.

I have a workbook that needs to pull data from another, closed workbook, based on dynamic references.

I of course found indirect didn't work on the constructed string, so I built a small piece of code that basically replaced the formula of cell B with the text of cell A which works a treat.

My problem is that if the closed work book doesn't exist I get a prompt asking me to browse for the file I can cancel past it and it causes no problems, but it's very irritating, I tried an iferror() which worked in filling the cell with a "Not yet available" string, but the prompt still came up.

Is there a way to prevent it. One suggestion from a colleague has been to create blanks of the files and then have them overwritten, which would work but seems a hassle.

Thanks in advance.
Sig.