VBA Open FilePath from FTP location - Excel 2016 error

Hi,

I use Excel 2013 and have some VBA code to open up and copy data from an excel file on a FTP site. It works flawlessly in Excel 2013, however every time I try this on a computer with Excel 2016 the program closes and open a new sheet. I've identified the line of code which causes this to happen but am having trouble identifying how to make it work with Excel 2016.

The line of code where it fails in 2016 is:
Set RawWB = Workbooks.Open(Filename:=FilePath, ReadOnly:=True)

I've verified that the user is able to open file on the FTP site so there is no FTP issue.

Thanks!

Please Login or Register  to view this content.

Thoughts on this?