Excel files update from Access

Status
Not open for further replies.

Michelle2

Posts: 35   +0
I have a problem with an Excel file that I want to auto update against data
in other Excel files - unfortunately the source files are created by Access
and so are Excel 95 format. The update works fine if the source files are
open but gives an error message if not. If I re-save the source file as Excel
2000 it works without the error. There will be circa 240 source files and
when updated by Access will be over written so it is not feasible to manually
convert the files.

Any ideas or has MS beaten me on this one? :blackeye:
 
Status
Not open for further replies.
Back