.xls files onto CD

[mnmhenry]

I am starting to send away some Excel files on CD. All goes well until... after copying the file onto the hard drive and then start using the file.. Somehow, the Read Only tick box in the file properties automatically ticks itself. The Excel files I use have many Save commands wich then fail because of this .....

can anyone shed some more light on this for me ??

Thanks again.

 

[royUK]

Hi

Try opening the file and saving as a different name.Or, open the CD files and right click and drag the files to your destination and choose "Move Here"
I think that might help

 

[mnmhenry]

Thanks for the reply. I can do this fine as I have discovered what is going on, but the customers I am forwarding these disks to, don't know about it and therefore, in their eyes, the disk or program is fault.....and really, it's not.

 

[Paul B]

I have had this problem also, I think it has something to do with the CD’s being read only, I have not found a way to record a file, excel or word, to a CD without it making them read only, and then having to right click on the file and change the properties before opening it. Maybe somebody here knows a way maybe a on open event to change the properties from read only?

 

[ThePencilQueen]

How about including the excel files in a self extracting (exe) zipped up file. That way at the other end the users would have to double click the exe file and you can specify for the excel files to be saved to the desktop of the user (ie onto the harddrive).

 

[dk]

Hello,

Put this procedure in your workbook's Open event. I just tested it and it worked fine:-

Private Sub Workbook_Open()
On Error Resume Next
FileSystem.SetAttr ThisWorkbook.FullName, vbNormal
ThisWorkbook.ChangeFileAccess xlReadWrite
End Sub

Hope this helps,
Dan

 

[Jack in the UK]

Hi Sorry this is a tad late but DK has saved the day i know only ZIp the files and then should work arround this

ANY compression will do this RAH, ACE, ZIP, and so on.

Jack

Free trial or sharware on cnet download.com or tucow.com all free and leagle if you need to try this or winzip.com for trial version