>>Hi all,
>>
>>I have an Excel application that is always up and running. It connects to many PLCs throughout the facility gathering information from machinery and updating a workbook every 12 hours. The links are always active, however, and must remain so.
>>At the time of the update the auto recover of Excel fires and creates a temp file with ever changing naming structures.
>>
>>I need to open the original table, and export information into a VFP table based on current values.
>>
>>When I attempted to import from the live workbook, I recieved sharing violation errors due to the links created by the machinery links.
>>
>>If I copy the file into a new directory I get all of the information from the time that the workbook was last saved.(New versions of excel don't appear to have the Auto Save option)
>>
>>If I go out to the Excel machine and manually press save, I can copy the excel workbook to a new directory without breaking any of the links and update my VFP tables.
>>
>>Is there a way to export excel files without breaking any of the links on the original or violating the shares created by the machines? Or, is there some kind of macro I can build to make the Excel sheet auto save?
>>
>>If you need more information let me know.
>>
>>Any help would be greatly appreciated.
>
>Chad,
>
>I believe, you have several ways to do it. One of the solutions is to copy Excel file with COPY file command, and then work with the new file. Another solution is to get the EXcel object using automation, and to work with activeworkbook.
>
>Good Luck

Thanks Yuri!
I appreciate the response. I am unable to use automation as the workbook gives me a file share error. So, COPY may be the only way to go. The only issue now is, I need to manually run out to the machine and press save on the open workbook. I just need some kind of macro to set up with Excel to Auto Save. Any suggestions?