LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default What is xlNormal?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please! Hide workbook title bar when WindowState = xlNormal Glauco Excel Discussion (Misc queries) 0 March 18th 07 10:43 PM


All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"