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 --- _______________________________________________ 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.
