check if linked server table column exists
You'll have to make a connection first using VBA and then check with sys.columns

SELECT COUNT(*)
FROM sys.columns c
WHERE c.object_id = OBJECT_ID('MyTable') AND c.name = 'ExpectedCol'


Or use COLUMNPROPERTY

That is, check the metadata separately trying to query the column