CSV File attributes

[samahiji]

Hello

I have Excel vba that merges CVSs files and produce one master file.

I want now to add file attributes to the master csv file. The date and time was easily retrieved using fileDateTime function. Is there a similar function to get the owner/author for that file?

 

[Tinbendr]

Document attributes are NOT stored in a CSV file. Only the text is stored. (Unless it's part of the text.)

If you want to store those values, you'll have to save it as something other than a CSV file.

 

[samahiji]

Thanks,

The csv file is being generated by each user who click a button in my sheet that combines all csv files in the directory. can we store the user that generate that csv in the generated file.

here is my first part:
http://www.mrexcel.com/forum/excel-questions/914289-merge-csvs-one-file.html

 

[Tinbendr]

Below this

        'Save text file as a Excel file
        Set WB = ActiveWorkbook

insert this

        'Insert the computer user name to the top of the dataset.
        Set Rng = WB.Worksheets(1).Range("A1")
        Rng.EntireRow.Insert
        Rng = Application.UserName

Keep in mind that a CSV file is a text file. It does not store any addition information about the file in the data. It just seems like it's a Excel file because Excel does a really good job of opening it without going through the import wizard.

 

[samahiji]

Thanks a lot.

work like a charm!! ?

I just shifted the output to another cell to keep the source data safe.