Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel - Access
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
Access data -work in Excel- save in Access | Excel Programming | |||
Getting Access Error Messages when running Access through Excel | Excel Programming |