Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I was looking for further clarification as to what saving an excel as
filetype:= xlNormal means. I have been unable to find a definition that goes beyond stating it is a normal workbook or that it's a constant equivalent to -4143. What is a "normal workbook" exactly? I would like to have a better understanding of what this means before I go ahead and use it. The reason I ask is because I am working on updating some macros to save a spreadsheet in a *.xls format (97-2003). This needs to run for users in Office 2003 and 2007. I had been creating an if statement to check application.version and running the appropriate syntax to save as *.xls until I accidentily stumbled across another workbook that used filetype:=xlNormal which runs in both versions and in both cases creates *.xls. Why does this work? Thank you in advance for your assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please! Hide workbook title bar when WindowState = xlNormal | Excel Discussion (Misc queries) |