Hex Edit Excel
 

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

Hex Edit Excel
 

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

Hex Edit Excel
 

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

Hex Edit Excel
 

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

--
Regards,
Tom Ogilvy




"Bogdan" wrote in message
...
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

Hex Edit Excel
 

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

RBS


"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