We've yet to find an elegant way around this since U2 doesn't have access to the environment variables on the client desktop. If you just have two or three users to code for you could handle it with a case statement. If you have more, you might want to create a database file to keep each user's path in. Or, as you mentioned, you could make sure every desktop uses the same path.
-John -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Thursday, September 19, 2013 9:52 AM To: U2 Users List Subject: Re: [U2] TU.TO.EXCEL path Hi All, I wrote a program to provide a file to download to Excel. It works fine for me but when I ask the helpdesk to run the report it fails with the error: Microsoft Excel cannot access the file 'c:\progra~1\micros~3\office13\'. The user's path is: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft Office\Microsoft Excel 2010.lnk How can I fix this? Do I have to always have Excel installed in the same path? Or can the path be stored in a table per user? Thanks for any help, Bruce Lunt _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
