MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Saving Data in a File

  Asked By: Meenachi    Date: Dec 08    Category: MS Office    Views: 816

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.

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).


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?



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Saving Data in a File Or get search suggestion and latest updates.