Hexidecimal Editting
 

Is there a way of making hexidecimal changes to files using VBA in excel?

I have a large number of files that require a small change making to them
and this would speed it up.

Ta

Andy

Hexidecimal Editting
 

Get a hex editor. There are plenty of free ones out there, search Google.

--
HTH

Bob Phillips

"Andibevan" wrote in message
...
Is there a way of making hexidecimal changes to files using VBA in excel?

I have a large number of files that require a small change making to them
and this would speed it up.

Ta

Andy

Hexidecimal Editting
 

This can be done using VBA's file access methods. There used to be a good
overview article on this subject at microsoft.com but it seems to have been
removed. This one is specific to binary access which may be what you're
interested in anyway.

http://support.microsoft.com/default...b;en-us;151335

--
Jim
"Andibevan" wrote in message
...
| Is there a way of making hexidecimal changes to files using VBA in excel?
|
| I have a large number of files that require a small change making to them
| and this would speed it up.
|
| Ta
|
| Andy
|
|

Hexidecimal Editting
 

Thanks Jim - that seems a good starting point - I am not certain what I am
after though.

The manual process is to open up the raw file in the hexi editor, then do an
Ascii search and replace, then save the file.

I am not sure whether this can be achieved easily using the binary file?
Can you do binary search and replace?


"Jim Rech" wrote in message
...
This can be done using VBA's file access methods. There used to be a good
overview article on this subject at microsoft.com but it seems to have been
removed. This one is specific to binary access which may be what you're
interested in anyway.

http://support.microsoft.com/default...b;en-us;151335

--
Jim
"Andibevan" wrote in message
...
| Is there a way of making hexidecimal changes to files using VBA in excel?
|
| I have a large number of files that require a small change making to them
| and this would speed it up.
|
| Ta
|
| Andy
|
|

Hexidecimal Editting
 

Thanks Bob - I have got XVI32 and this has some scripting capabilities but
there would be a bit of a learning curve.

"Bob Phillips" wrote in message
...
Get a hex editor. There are plenty of free ones out there, search Google.

--
HTH

Bob Phillips

"Andibevan" wrote in message
...
Is there a way of making hexidecimal changes to files using VBA in excel?

I have a large number of files that require a small change making to them
and this would speed it up.

Ta

Andy

Hexidecimal Editting
 

You can open files in Binary mode which allows you to get or put byte
into the file in a random fashion specified by address.

Type the word 'Open' into the VBE and press F1 with the cursor over th
word for more information.

Regards

Ric

--
Rich_
-----------------------------------------------------------------------
Rich_z's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread.php?threadid=38609

Hexidecimal Editting
 

I assumed you were looking to write your own low level binary search/replace
routines in VBA. There is nothing in Excel to do this of course and no
finished functions built into VBA to do it either, only the raw tools with
which it can be done with some work. Maybe using an editor of some sort is
a better way to go if you can find one.

--
Jim
"Andibevan" wrote in message
...
| Thanks Jim - that seems a good starting point - I am not certain what I am
| after though.
|
| The manual process is to open up the raw file in the hexi editor, then do
an
| Ascii search and replace, then save the file.
|
| I am not sure whether this can be achieved easily using the binary file?
| Can you do binary search and replace?
|
|
| "Jim Rech" wrote in message
| ...
| This can be done using VBA's file access methods. There used to be a good
| overview article on this subject at microsoft.com but it seems to have
been
| removed. This one is specific to binary access which may be what you're
| interested in anyway.
|
| http://support.microsoft.com/default...b;en-us;151335
|
| --
| Jim
| "Andibevan" wrote in
message
| ...
|| Is there a way of making hexidecimal changes to files using VBA in excel?
||
|| I have a large number of files that require a small change making to them
|| and this would speed it up.
||
|| Ta
||
|| Andy
||
||
|
|
|

Hexidecimal Editting
 

You may well be right Jim - I think It is probably easier to build a script
in XVI32. (freeware hex editor I found the other day) - XVI32 seems good as
you can build scripts and then run the scripts in conjunction with the hex
editor from the command line - this sounds like an easier solution than
trying to re-invent the wheel by building a hex interface for VB.



"Jim Rech" wrote in message
...
I assumed you were looking to write your own low level binary search/replace
routines in VBA. There is nothing in Excel to do this of course and no
finished functions built into VBA to do it either, only the raw tools with
which it can be done with some work. Maybe using an editor of some sort is
a better way to go if you can find one.

--
Jim
"Andibevan" wrote in message
...
| Thanks Jim - that seems a good starting point - I am not certain what I am
| after though.
|
| The manual process is to open up the raw file in the hexi editor, then do
an
| Ascii search and replace, then save the file.
|
| I am not sure whether this can be achieved easily using the binary file?
| Can you do binary search and replace?
|
|
| "Jim Rech" wrote in message
| ...
| This can be done using VBA's file access methods. There used to be a good
| overview article on this subject at microsoft.com but it seems to have
been
| removed. This one is specific to binary access which may be what you're
| interested in anyway.
|
| http://support.microsoft.com/default...b;en-us;151335
|
| --
| Jim
| "Andibevan" wrote in
message
| ...
|| Is there a way of making hexidecimal changes to files using VBA in excel?
||
|| I have a large number of files that require a small change making to them
|| and this would speed it up.
||
|| Ta
||
|| Andy
||
||
|
|
|