Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Formatting!
Hello all!
A quick question. I was trying to save a worksheet ina workbook in certain format. I tried the following two ways. ActiveSheet.SaveAs FileName:=filesaveName, FileFormat:=xlText ActiveSheet.SaveAs FileName:=filesaveName, FileFormat:=xlTextWindows I was wondering what is the difference between the two fileformat here? Apparantly both work well. Thanks a bunch. Regds, Arun. Iyer Vtec Cor -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Formatting!
xlText is certainly a valid FileFormat enumerator. It may not be in the
current listing in help, but the current listing didn't have the fancy names until xl97. Before then it was simply xlText. Obviously the numerical value is what is actually used and as you stated, they are the same. Just to elaborate, recording a macro records: ActiveWorkbook.SaveAs Filename:="C:\Book4.txt", FileFormat:=xlText, _ CreateBackup:=False Similar before xl97: ? xlPasteFormulas -4123 ? xlFormulas -4123 ? xlPasteSpecialOperationAdd 2 ? xlAdd 2 and the list goes on and on. -- Regards, Tom Ogilvy "Brad Vontur" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Formatting!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting .txt File | Excel Discussion (Misc queries) | |||
Re-formatting when saving as HTM file. | Excel Discussion (Misc queries) | |||
Is it possible to link cell formatting in Excel from file to file | Excel Discussion (Misc queries) | |||
Formatting of Data from .CSV file | Excel Worksheet Functions | |||
File formatting! | Excel Programming |