View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
InNeedOfHelp! InNeedOfHelp! is offline
external usenet poster
 
Posts: 1
Default Export CSV File, set Windows Read-Only attribute

I need to export a CSV file from an excel sheet with Window Read-Only
attributes (ie. when I right-click on the CSV file from folder view, I need
the Read-Only box checked).

Is there a way to do this with an Excel Marco?

My current code which does not do the functionality described above, is as
follows:
ActiveWorkbook.SaveAs "C:\Test\" + Filenamer, xlCSV, , password, True

Even if this code worked, it is read-only in the EXCEL sense right? I need
to be able to protect the contents even if I open the CSV file with Notepad
or Word.