Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing hex numbers to a binary file
On Sep 25, 9:55 pm, Fan924 wrote:
I finally figured this out with help from some of you. Open a file, convert hex to decimal numbers, convert to a character (Chr Function), and write to file. It works great. Problem..... I can't figure how to do a HEX2DEC conversion within the macro. Just to test all this, I created a column next to the hex data using the HEX2DEC function. I would like to do this without creating a column of decimal numbers. Any ideas from the expert? Have a look here. http://www.vbaexpress.com/kb/getarticle.php?kb_id=307 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing hex numbers to a binary file
My fault again, I forgot to specify Excel 97.
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing hex numbers to a binary file
just test&use it.
as to my experience, 99.99999% of excel macro is compatible with all versions, back to the excel-5 from the year 1993 "Fan924" je napisao u poruci interesnoj oups.com... My fault again, I forgot to specify Excel 97. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing hex numbers to a binary file
It didn't work.
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing hex numbers to a binary file
it couldn't be a version 97-2002 problem, maybe something else
if you are still interested, please clarify the way "it didn't work" you got the vba compiler error message, or wrong result? "Fan924" je napisao u poruci interesnoj oups.com... It didn't work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Binary Numbers | Excel Discussion (Misc queries) | |||
How can I do AND operation on two binary numbers in MS Excel? | Excel Programming | |||
large binary numbers | Excel Worksheet Functions | |||
Binary numbers longer than 10 characters | Excel Programming | |||
Binary Numbers longer than 10 characters | Excel Worksheet Functions |