Hex Edit Excel

[Guest]

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

 

[Tom Ogilvy]

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.

 

[Guest]

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]

http://sc.openoffice.org/excelfileformat.pdf

 

[RB Smissaert]

How about make some VBA code that opens all the files for you, makes the
changes and saves the new files?

RBS