Thanks both. I am off to bed now so will try your suggestions in the morning.
Thanks Peter Tracy wrote: 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. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Steve Ellenoff Sent: 25 March 2009 22:16 To: [email protected] Subject: RE: File Copy Problem I've not tested this, but I'm pretty sure if you use Win32API CopyFile from VFP it will retain case for the filename. At 04:49 PM 03/25/2009, you wrote: >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 > > > > > >--- StripMime Report -- processed MIME parts --- >multipart/alternative > text/plain (text body -- kept) > text/html >--- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] 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.
