Not sure if this is elegant or an ugly hack, but running "start /path/to/excel/file.xlsx" (or perhaps "cmd /c start ..file.xlsx") works, and can be handy if some people use Excel and others use OpenOffice - it's driven by whatever file associations you have in windows explorer.
Regards, Ian -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of John Hester Sent: Thursday, September 19, 2013 10:23 AM To: U2 Users List Subject: Re: [U2] TU.TO.EXCEL path 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: [email protected] [mailto:[email protected]] 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ----------------------------------------- IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
