Data Link Properties

[Starkey]

Morning all

I have a programme (VBA macro) that extracts data from all excel workbooks that are moved to a specific folder and adds it to a master workbook. All works fine except for those rare instances where the workbook appears previously to have been connected to a data source. In such a scenario I get a pop up box, labelled 'Data Link Properties', which asks me connect to a data source

Is there anyway that I can bypass this pop up box please? I'm not able to reconnect to a data source because I've no idea where the data originated from

Thanks

 

[Starkey]

Hi Nemmi

Thanks for taking the time & trouble Nemmi

I did do something similar yesterday and I still got the pop up box. I assumed it was because there was no active connection hence nothing to delete. But to the uninitiated like me it's almost as if my code spots when I open certain workbooks that the information contained within it originated from an access database (or whatever) and it's trying to re-establish that connection again!