I have been running Excel automation code in Access to create some reporting. Specifically I am using code to send tables to an existing spreadsheet, open it, and run pivot table.
     Sometimes when this procedure runs it fails and I receive an error that the 'Remote server machine does not exist or is unavailable.' This occurs about half the time I run this process and occurs whether its run across a network or on a local machine. Does anyone know the cause of this or how to prevent it?
     Microsoft says it has to do with network settings which I don't buy because it happens when not on a network as well. Any suggestions are appreciated.