View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Brad Vontur[_2_] Brad Vontur[_2_] is offline
external usenet poster
 
Posts: 16
Default File Formatting!

xlText is not a valid FileFormat enumerator. That's actually a pivottable constant. Coincidentally the value of the xlText constant is the same as that of the FileFormat xlCurrentPlatformText constant

I'm sure the property of FileFormat has a function to determine which platform you're running, and finds out that you're using Windows. So xlTextWindows and xlCurrentPlatformText should ultimately give you the same result. But you should use xlTextWindows as it's probably faster

-Brad Vontur