Unfortunately, I don't think I can do it that way because we are using SB+ and 
TU.TO.EXCEL is the utility that is used for sending data to Excel. I don't want 
to mess with that code. I was just hoping there was somewhere to store the 
user's path.
-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of McGowan, Ian
Sent: Thursday, September 19, 2013 12:18 PM
To: U2 Users List
Subject: Re: [U2] TU.TO.EXCEL path

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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 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: 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
-----------------------------------------
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
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

Reply via email to