Hi,
In Access I have several linked data sources (each are excel spreadsheets). My code performs functions on each linked data source, but sometimes one of the spreadsheets may not have a worksheet at all (so the link will not be able to pull back any data).
Question is, how do I write an if else statement so that if there is no worksheet in the linked data source, it jumps to the next piece of code?
Many thanks...
