I want to save data in text format (possibly others in the future)
– not necessarily a sheet. Initially, I was thinking variables like
the old OPEN... || Print/WRITE X, Y, Z || CLOSE of good 'ole Basic.
I realized one solution is to put the data in a sheet, in the
proper format, then save that sheet.
SO...
Two related questions
1 - The Excel 8 Object browser gives me these FileType codes
xlnormal -4143
xlCSV 6
xlCurrentPlatformText -4158
Are these the FileFormat Codes to use in the recent Tou / David
Horowitz example?
ActiveWorkbook.SaveAs Filename:=strFN, FileFormat:=xlNormal
Is there a Tab delimited format code? If not, of course, I can just
build my own tab delimited text in a single cell and save as plain
text (or CSV for that matter).
THEN...
2 - In the Excel 8 Object Browser, I see (Worksheet Class, SaveAs member):
Sub SaveAs(Filename As String, [FileFormat], [Password],
[WriteResPassword], [ReadOnlyRecommended], [CreateBackup], [AddToMru],
[TextCodepage], [TextVisualLayout])
But I am confused by this. This is not a Property nor a Method that I
would apply to an Object like in the above example, but a procedure
(Sub) ... that I didn't put in my macro space!? How would I use it?
Is this the same as in the above example, just using another way to
use the Method? Should I bother given Tou/Horowitz?