Re: Excel Add-in on 2008 RDS (1302 Views)
Reply
Advisor
Luke Jones
Posts: 29
Registered: ‎09-14-2009
Message 1 of 21 (1,326 Views)
Accepted Solution

Excel Add-in on 2008 RDS

We recently moved our Terminal Services host to 2008 32 bit, Remote Desktop solution.

 

The problem that we are now encourtering is that we cannot get the Excel add in for TRIM 6,  2.4.1240 with office 2007 working. I suspect that the addin is not in the support matrix for this combination, however any ideas will be appreciated.

 

As as admin user it the addin works correctly.

 

Users, however throw a 1640 msi error, which basically meant that they cannot install an MSI through a remote session.

(they can only get this far if I add: [HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\Installer]
"disablemsi"=dword:00000000)

A bit of research tells us that the MSI installation will be no good:
http://msdn.microsoft.com/en-us/library/aa368353%28v=vs.85%29.aspx
Nonadministrative users can never perform installations from a client session. 

 

I am thinking that If I manually put all the componants of this MSI into the user session it should work. The files are all installed and I have tried importing all the HKCU registry entries that are contained within the MSI, however it does not register correctly with Excel. I am guessing that .net caspol scripts need to get executed on a per user basis, but dunno how to find or run these.

 

Currently we only have 2 options: run without the addin, or make everyone admin users. Neither of which are desirable!

Any clues??

Please use plain text.
Honored Contributor
Grundy
Posts: 2,814
Registered: ‎02-16-2009
Message 2 of 21 (1,326 Views)

Re: Excel Add-in on 2008 RDS

The old Excel add-in from 6.2.X requires that each user that will use it has to run the MSI in their profile.

As you can imagine, this isn't an ideal solution on a terminal server setup...

 

In 7.1, the new integration moves away from individual MSI's for Office integration and goes back to a tick box and COM add-in solution that has none of this hassle.

So there is a potential upgrade path to make life easier here.



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

Kapish.com.au
Please use plain text.
Advisor
Luke Jones
Posts: 29
Registered: ‎09-14-2009
Message 3 of 21 (1,326 Views)

Re: Excel Add-in on 2008 RDS

I was aware that there are several improvements in the next version, however we have well mapped projects and a TRIM upgrade is on the distant horison. Given our current version is in support, I was anticipating some different advice than to upgrade.  :smileysad: 

Please use plain text.
Honored Contributor
EWillsey
Posts: 1,757
Registered: ‎04-20-2010
Message 4 of 21 (1,326 Views)

Re: Excel Add-in on 2008 RDS

You can do this without upgrading by putting the Excel GUID into the ActiveSetup registry section of the TS Local Machine hive. It'll ensure that when the user has logged on but never had the Excel MSI executed, that it'll execute it and prepare the profile properly.

Please use plain text.
Honored Contributor
Grundy
Posts: 2,814
Registered: ‎02-16-2009
Message 5 of 21 (1,326 Views)

Re: Excel Add-in on 2008 RDS

Thanks Erik. :smileyhappy:  Kudos!

 

Luke, upgrading is always a good option when talking about Office Integration! (The Excel stuff was especially frustrating to get running for all users...)     :smileywink:



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

Kapish.com.au
Please use plain text.
Advisor
Luke Jones
Posts: 29
Registered: ‎09-14-2009
Message 6 of 21 (1,326 Views)

Re: Excel Add-in on 2008 RDS

Nice one Erik. Thanks

 

I aussme you already have this working. i better do some reading up on ActiveSetup....

Please use plain text.
Advisor
Luke Jones
Posts: 29
Registered: ‎09-14-2009
Message 7 of 21 (1,326 Views)

Re: Excel Add-in on 2008 RDS

Not convinced active setup is going to work. Active setup calls msiexec which is where I am coming unstuck with the user permissions running an MSI.

 

I have been experimenting with only trying to repair the user settings only (/fu) but still getting errors.

 

I need to bypass the entire MSI process somehow...

Please use plain text.
Honored Contributor
Grundy
Posts: 2,814
Registered: ‎02-16-2009
Message 8 of 21 (1,326 Views)

Re: Excel Add-in on 2008 RDS

I just remembered that in the later 6.2.X releases we had issues with Per User deployment via Group Policy.

(I found the problem myself and reported it to R&D)

 

*Forehead slap for forgetting*

 

If you deployed a Per User package, it will only work for admin users.

R&D fixed this for 6.2.5 under CR 38723

I know you didn't want to upgrade, but it's possible these fixes may have a positive effect on your current situation.

 

If upgrading is still definitely out of the question, you can try running the CASPOL commands manually per user (via a login script or something).

This is effectively the part that is run by the MSI that is needed for every user.

 

The only problem will be getting those CASPOL commands for that version you're running...



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

Kapish.com.au
Please use plain text.
Advisor
Luke Jones
Posts: 29
Registered: ‎09-14-2009
Message 9 of 21 (1,326 Views)

Re: Excel Add-in on 2008 RDS

Thanks Grundy. Yes that is what I was thinking.

 

The files are all in place.

I have managed to extract the reg entries.

I have an existing script to populate these and do other things.

I just need those scripts that run (I don't think it does anything else). There are 3 or 4 of them I believe...

 

inside the msi, it runs these custom actions, so i guess these will be the ones I can work with:

 

-u -rg "TOWER.dmsnet"

 

-pp off -u -ag "TOWER.dmsnet" -strong -file "[INSTALLDIR]tsjExcel12AddIn.dll" "tsjExcel12AddIn" -noversion FullTrust -n "tsjExcel12AddIn" -d "Code group for tsjExcel12AddIn"


-pp off -u -ag All_Code -url "[INSTALLDIR]*" Nothing -n "TOWER.dmsnet" -d "Code group for TRIM Context DMS assemblies"


-pp off -u -ag "TOWER.dmsnet" -strong -file "[INSTALLDIR]tsjdmsnet.dll" "tsjdmsnet" -noversion FullTrust -n "tsjdmsnet" -d "Code group for tsjdmsnet"


 

I'll continue to investigate....

Please use plain text.
Honored Contributor
Grundy
Posts: 2,814
Registered: ‎02-16-2009
Message 10 of 21 (1,326 Views)

Re: Excel Add-in on 2008 RDS

Yep, those are the commands, but they aren't formatted in a friendly way and aren't using the right syntax...

 

I'll hassle the MSI guru upstairs and get the CASPOL commands from him. (3 commands from memory)

 

 



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

Kapish.com.au
Please use plain text.
Occasional Advisor
Ben Giles
Posts: 11
Registered: ‎05-13-2009
Message 11 of 21 (1,343 Views)

Re: Excel Add-in on 2008 RDS

Hi Grundy / all

 

Luke has left me with this wonderful problem, I was hoping you had some success getting those commands from your team member?

 

Any help appreciated!

Please use plain text.
Honored Contributor
Grundy
Posts: 2,814
Registered: ‎02-16-2009
Message 12 of 21 (1,343 Views)

Re: Excel Add-in on 2008 RDS

Luke was pretty close pulling those commands from the MSI.
I've attacked a txt file from the MSI dev with the CASPOL commands.

 

Try running these commands for one of the users having issues with the add-in.

 



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

Kapish.com.au
Please use plain text.
Occasional Advisor
Ben Giles
Posts: 11
Registered: ‎05-13-2009
Message 13 of 21 (1,343 Views)

Re: Excel Add-in on 2008 RDS

Ok so now the caspol portion of the extracted MSI is working.

 

We can see the COM add-in under excel, but everytime we try to enable this we get a runtime error:

 

Not Loaded. A runtime error occurred during the loading of the COM Add-in

 

Any ideas?

 

We have run the following registry script to apply the correct settings:

 

Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Excel12AddIn]"CommandLineSafe"=dword:00000001"LoadBehavior"=dword:00000003"FriendlyName"="Excel12AddIn""Manifest"="C:\\Program Files\\TRIM Context\\tsjExcel12AddIn.dll.manifest""Description"="Excel12AddIn -- TOWER Software addin for Excel 2007"

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options]"OPEN"="\"C:\\Program Files\\TRIM Context\\TSJXL12.xlam\""
[HKEY_CURRENT_USER\Software\Classes\CLSID\{E9335F8A-875D-4A92-A35F-5DE83B2B197A}]@="Excel12AddIn -- TOWER Software addin for Excel 2007"
[HKEY_CURRENT_USER\Software\Classes\CLSID\{E9335F8A-875D-4A92-A35F-5DE83B2B197A}\InprocServer32]"ManifestLocation"="C:\\Program Files\\TRIM Context\\""ManifestName"="tsjExcel12AddIn.dll.manifest"@="C:\\Program Files\\Common Files\\Microsoft Shared\\VSTO\\8.0\\AddinLoader.dll""ThreadingModel"="Both"
[HKEY_CURRENT_USER\Software\Classes\CLSID\{E9335F8A-875D-4A92-A35F-5DE83B2B197A}\ProgID]@="Excel12AddIn"
[HKEY_CURRENT_USER\Software\Classes\CLSID\{E9335F8A-875D-4A92-A35F-5DE83B2B197A}\Programmable]@=""
[HKEY_CURRENT_USER\Software\Classes\CLSID\{E9335F8A-875D-4A92-A35F-5DE83B2B197A}\VersionIndependentProgID]@="Excel12AddIn"

[HKEY_CURRENT_USER\Software\Classes\Excel12AddIn]
[HKEY_CURRENT_USER\Software\Classes\Excel12AddIn\CLSID]@="{E9335F8A-875D-4A92-A35F-5DE83B2B197A}"






Please use plain text.
Honored Contributor
Grundy
Posts: 2,814
Registered: ‎02-16-2009
Message 14 of 21 (1,343 Views)

Re: Excel Add-in on 2008 RDS

Is the .dll registered for each user? (reg keys should do, but try registering manually to be sure?)

Also, are the prerequisites installed?

From the doco:

 

Installing the pre-requisites on each target computer
1 Install the Microsoft Visual Studio Tools for the Office system 3.0.
   If it is not already installed, download vstor30.exe from
   http://www.microsoft.com/downloads/details.aspx?FamilyId=54EB3A5A-0E52-40F9-A2D1-EECD7A092DCB&displa... and install it.
2 Install Microsoft Office 2007
3 Install Microsoft Office 2007 Primary Interop Assemblies (PIA)
   a Download o2007pia.msi from
   http://www.microsoft.com/downloads/details.aspx?familyid=59DAEBAA-BED4-4282-A28C-B864D8BFA513&displa...
   b Install o2007pia.msi



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

Kapish.com.au
Please use plain text.
Occasional Advisor
Ben Giles
Posts: 11
Registered: ‎05-13-2009
Message 15 of 21 (1,343 Views)

Re: Excel Add-in on 2008 RDS

How would I register manually for each user?

 

Yes all the pre-reqs are installed

 

Thanks!

Please use plain text.
Honored Contributor
Grundy
Posts: 2,814
Registered: ‎02-16-2009
Message 16 of 21 (1,343 Views)

Re: Excel Add-in on 2008 RDS

Try getting a user with the problem to run a regsvr32 for the excel .dll.

 



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

Kapish.com.au
Please use plain text.
Occasional Advisor
Ben Giles
Posts: 11
Registered: ‎05-13-2009
Message 17 of 21 (1,343 Views)

Re: Excel Add-in on 2008 RDS

I get the following error:

 

The module "tsjExcel12AddIn.dll" was loaded but the entry-point DllRegisterServer was not found.

 

Make sure that  "tsjExcel12AddIn.dll" is a valid DLL or OCX file and then try again.

 

:smileysad:

Please use plain text.
Advisor
Luke Jones
Posts: 29
Registered: ‎09-14-2009
Message 18 of 21 (1,339 Views)

Re: Excel Add-in on 2008 RDS

G'Day All.

 

Back from leave and not thinking about this issue for a few weeks. In my absence the decision was made to grant the users (only a small amount at this stage) admin rights to the server, install the add-in and then remove these admin rights.

 

Thanks to everyone who assisted.

Please use plain text.
Honored Contributor
Grundy
Posts: 2,814
Registered: ‎02-16-2009
Message 19 of 21 (1,336 Views)

Re: Excel Add-in on 2008 RDS

Thanks for the update Luke.

Sorry it was such a hassle to get running!



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

Kapish.com.au
Please use plain text.
Occasional Contributor
andyroo54
Posts: 4
Registered: ‎07-12-2011
Message 20 of 21 (1,304 Views)

Re: Excel Add-in on 2008 RDS

Hi,

 

Can anyone tell me where to download the TRIM Excel 2007 add in msi from? We have 6.2.5 and run now mostly Office 2010, but one of our users wants the TRIM ad in for Excel, and I read somewhere that 2007 add in will work ok, but I can't find where to get the MSI?

Please use plain text.
Honored Contributor
Grundy
Posts: 2,814
Registered: ‎02-16-2009
Message 21 of 21 (1,302 Views)

Re: Excel Add-in on 2008 RDS


andyroo54 wrote:

Hi,

 

Can anyone tell me where to download the TRIM Excel 2007 add in msi from? We have 6.2.5 and run now mostly Office 2010, but one of our users wants the TRIM ad in for Excel, and I read somewhere that 2007 add in will work ok, but I can't find where to get the MSI?


The MSI is on the 6.2.5 ISO/CD.

 



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

Kapish.com.au
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation