Couldn't resist it had to come back and test it. Thanks it worked perfectly
Peter -----Original Message----- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: 25 March 2009 22:16 To: profox@leafe.com Subject: RE: File Copy Problem You can use an API Declare Integer MoveFile in WIN32API string@, string@ MoveFile(lcOldFileName, lcNewFileName) This will respect the casing of the file, and rename it. HTH, Tracy -----Original Message----- From: Peter Hart Sent: Wednesday, March 25, 2009 5:50 PM Hi Does anyone know of a way to make sure when a file is copied to another file the new file will keep its case. lcOldFileName = "RAB-LH-8029 25-03-2009.xls" lcNewFileName = "RAB-LH-8029a25-03-2009.xls Copy (lcOldFileName) to (lcNewFileName) shows up in Explorer as "rab-lh-8029a25-03-2009.xls" I am using OLE with Excel to produce a purchase Order. When the Client amends the P.O. I want to check to make sure there is an old one, add a letter to the name then copy to the new name and delete the old one. Then save the spreadsheet with the old name. Thus having an audit trail of alterations to the P.O. I couldn't see a way in Code of simply renaming the file. But this would still leave me with the same case problem, I think. TIA Peter Peter Hart Computers [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/a57fa4cf19531343a2ee11b57db8e3af04c...@server.peterhartcomputers.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.