Tom

thanks for the quick response but the Hed Edit has proven to safe time, big
time !.
When doing this manually I need to change this.

* Open the spreadsheet
* Select the first sheet which I want to change
* Perform the manual changes (these are several steps !!)
* Repeat this step for all other sheets and change the exact same "path",
without making any mistakes.
* Save and exit the workbook.
* Repeat this again for all workbooks 200

My question remains:

How can Hex-Edit the spreadsheet AND change the path to anything size.?

Bogdan

"Tom Ogilvy" wrote:

if you right click on the data table in excel, you get a dialog that will
allow you to change the path. Using a HEX editor would be counter
productive.

--
Regards,
Tom Ogilvy


"Bogdan" wrote in message
...
Hi

I have developped many spreadsheets which get data from MS Access (Method:
Get External Data).

Now I need to move all source-databased and with that I have to change the
path where the source data is stored. I've managed to change this using
the a
Hex Editor however there seems to be one limitation.

The length of the path-name must be the same otherwise the file get's
corrupt. It looks like some other attributes needs to be changed.

How can Hex-Edit the spreadsheet AND change the path to anything size.?

Any input is appreciated
Bogdan