Trying to copy pdf files from one folder to another and in the process "rename" the files being copied.
The "name" is actually a tattoo number with a format like (5K7890, 6KB789, KN1234), and we need the letters to be uppercase. The process works, except that the destination file name will NOT maintain the uppercase value. Maybe there is some kind of WIN OS setting causing the letters to switch to lowercase as the "Tattoo" is a fieldname in the table and all the data is uppercase letters. Copy File UPPER(mnamefile) To (packet_path)+ tattoo + ".PDF" Stepping through the code shows these values: Mnamefile = "C:\2013 HBURG\HSFWITHDAM\FLOWER LANE.PDF" Packet_path = "C:\2013 HBURG\HSFWITHTATTOO\" Tattoo = "5K7890" The newly copied and renamed file becomes " 5k7890.pdf", but needs to be "5K7890.PDF" James E Harvey M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
