Named Ranges Being Added On Some Files And Not Others Using VBA

[robertjamesrigg]

Hi,

I have a VBA procedure which runs through a collection of files and as part of the process adds two named ranges. All the files are processed in the same way and all have been copied from the same template. The problem is that they are not being added in some files such that they are visible in Excel and cannot be used by the Access TransferSpreadsheet method. I've even explicitly set the visible property of the range to True.

Further if I reference the ranges in VBA they are there.

Thanks in advance for any help provided,

Robert.