Now let me get this straight. You want to replace the information daily with
new information <<export and replace the old info with the new>> BUT you want
to keep the links to the old data that you replaced <keep the links I have
created when I exported the first one>???
--
Gary Brown
gary_brown@ge_NOSPAM.com
"tamxwell" wrote:
> I built an Access database which export the daliy (new) figures to Excel to
> the desktop. One of the queries is for pulling all the information for a
> Credit Manager (CM). I then need to link this data to a summary Workbook. So
> each day I want to go to my database, pick the CM's data, export and replace
> the old info with the new, and keep the links I have created when I exported
> the first one. When I exported the first, I linked it to a number of
> spreadsheets. Any thoughts? I get an error telling me that It cannot expand
> the named range. If I rename it then I would have to reset all my links.
Bookmarks