Thanks for your input, Larry.

I've tried the altenative of putting the price update data in MS Access
reports that I've formatted to look as much like the spreadsheets as
possible, but that alternative got shot down by marketing. They want the
spreadsheets they've always had.

They are ancient but much loved, these spreadsheets. They are are also
strictly and heavily formatted with the relevant price cells on each sheet
in different places and with the effective dates and superceded dates
embedded in paragraphs of text.

They are also resistant to manipulation by Worksheet Macro or by
transferring a recordset from Access. There's nowhere to transfer it to...
The operation, in either case would have to address the Spreadsheets page by
page and cell by cell, and in the worst case offender there are about twenty
five pages. In other words, such programatic manipulation would require many
hundreds of separate operations, each slightly different.

My solution, failing a workaround less tedious than that, We're just gonna
keep at least one PC at corporate running Office 2000.

Probably the best idea anyway.

Jim S.