Re: [U2] TU.TO.EXCEL path

2013-09-19 Thread Lunt, Bruce
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...

Re: [U2] TU.TO.EXCEL path

2013-09-19 Thread Jo Lester
Check SB file TUBP (or TUINSERTS) DOS.PATH.H either SYSTEM(101) or $TEMP > From: bl...@shaklee.com > To: u2-users@listserver.u2ug.org > Date: Thu, 19 Sep 2013 17:02:43 + > Subject: Re: [U2] TU.TO.EXCEL path > > That is the problem. I never enter a path. The system is reading it from > som

Re: [U2] TU.TO.EXCEL path

2013-09-19 Thread McGowan, Ian
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 --

Re: [U2] TU.TO.EXCEL path

2013-09-19 Thread Lunt, Bruce
The system is HP9000 running Unidata 7.1 -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

Re: [U2] TU.TO.EXCEL path

2013-09-19 Thread John Hester
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 p

Re: [U2] TU.TO.EXCEL path

2013-09-19 Thread Lunt, Bruce
That is the problem. I never enter a path. The system is reading it from somewhere. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aaron Titus Sent: Thursday, September 19, 2013 9:58 AM To: U2 Users List Subject: R

Re: [U2] TU.TO.EXCEL path

2013-09-19 Thread Aaron Titus
What about not specifically putting a path at all, but rather just the executable name and allow windows to find the executable in the path automatically? *Aaron Titus* Senior Software Engineer F.W. Davison & Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Thu, Sep 19, 2013 at 12:52 PM, Lu

Re: [U2] TU.TO.EXCEL path

2013-09-19 Thread Lunt, Bruce
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 Men