Thread: Hex Edit Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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