Hex Edit Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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
 
How about make some VBA code that opens all the files for you, makes the
changes and saves the new files?

RBS
 
Back
Top