Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New file format constants
I would like to know the hexidecimal values of some new file format constants
in Excel 2007. - xlOpenXMLWorkbook - xlExcel8 I would like to save a worksheet as an (old) XLS file in Excel 2007 from my Delphi component so I need to now the hexadecimal value of xlExcel8. I also noticed that saving a file with the xlExcel9795 constants gives an exception. Doesn't support Excel 2007 this any more ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
New file format constants
Hi ,
Try this one : Hi, 1. On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak box 2. Sub ChgtoHex() [a1].Formula = "=dec2hex(" & xlExcel8 & ")" MsgBox "Hex Value of xlExcel8 is: " & [a1] [a1].Formula = "=dec2hex(" & xlOpenXMLWorkbook & ")" MsgBox "Hex Value of xlOpenXMLWorkbook is: " & [a1] [a1].Formula = "=dec2hex(43)" MsgBox "Hex Value of xlExcel9795 is: " & [a1] [a1] = [a1] End Sub I hope this will help you... -- Regards, Halim "StefanCr" wrote: I would like to know the hexidecimal values of some new file format constants in Excel 2007. - xlOpenXMLWorkbook - xlExcel8 I would like to save a worksheet as an (old) XLS file in Excel 2007 from my Delphi component so I need to now the hexadecimal value of xlExcel8. I also noticed that saving a file with the xlExcel9795 constants gives an exception. Doesn't support Excel 2007 this any more ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format .txt file contents to numeric format will not work - help! | Excel Discussion (Misc queries) | |||
how to format a Docmd to pull in an Access file in Text format | Excel Programming | |||
how to format a Docmd to pull in an Access file in Text format | Excel Programming | |||
constants | Excel Discussion (Misc queries) | |||
constants | Excel Programming |