AnsweredAssumed Answered

Excel Add-on for Command Expert

Question asked by ollyt on Apr 26, 2012
Latest reply on Aug 30, 2012 by hognala

Like • Show 0 Likes0
Comment • 4

Hi all,

Apologies if this is not really the correct forum for this topic, but it didn't seem to fit anywhere else!

I have just started using Command Expert to control an MXA. The installation went fine, though it did ask me for a Mat Lab licence which i didn't have available to enter...
The program works beautifully and I have no issues interacting and controlling the MXA through the Command Expert GUI. However no "Command Expert" tab has appeared in Excel. I'm running the 2010 version on win XP...

Any ideas how I get it to appear?

Thanks in advance for your help!

Best regards,

Olly

No one else has this question

Outcomes

hognala

Apr 26, 2012 3:55 PM

Hi Olly

Just to be 100% sure, you don't see the Command Expert ribbon item like in the attached spreadsheet?

What version of Command Expert do you have installed? Is it 1.0 or 1.1? If you have 1.0 installed, I'd recommend that you download and install 1.1 from www.agilent.com/find/commandexpert

When you run the following command at a commandline, does Excel show up in the list?

*reg query HKEY_LOCAL_MACHINE\SOFTWARE\Agilent\CommandExpert\Addons*

I have attached a couple of batch files in the *xp ce excel batch files.zip* file. Do the following to try to install the addin to Excel:

1) Make sure that Command Expert and Excel are closed
2) run *install excel vsto.bat* by double-clicking it
3) does the message say that it installed the addin correctly? If so, can you see Command Expert in Excel now? If not, continue to step 4.
4) Make sure that Command Expert and Excel are closed
5) run *uninstall then reinstall excel vsto.bat* by double-clicking it
6) Does the first message say that it was able to uninstall the addin successfully? If not, post the error message
7) Does the second message say that it was able to install the addin successfully? If not, post the error message
8) Can you see Command Expert in Excel now?

Attachments

xp ce excel batch files.zip555 bytes
CommandExpertinExcel.png66.8 KB

Actions

ollyt @ hognala on Apr 27, 2012 1:19 AM

Hi Hognala,

Thanks for your reply! After following your instructions it has finally appeared! But just for your info....

You are correct in that the Command Expert ribbon was not displaying like in the attached screenshot.
I am running version 1.1 of Command Expert.
After running the reg query it returned the following:
EXCEL REG_SZ
After running the first batch query you provided (install excel vsto.bat) I opened excel and it appeared :)

Thanks very much for your help, it is much appreciated!

Now I can finally start playing!

Olly

Actions

mikee27tan Aug 30, 2012 5:38 AM

Can anybody help here.

I installed command expert on my PC and the Excel add-ins did not appear also
upon running the batch file, the add-in appeared but its kinda taking long to run
around 45 seconds to roughly 2 minutes.

I just downloaded all this and installed it on our Test PC for testing on our
Agilent Devices.

I hope someone could help.

Actions

hognala

@ mikee27tan on Aug 30, 2012 7:30 AM

What version of Excel are you using?
What OS are you on?

What version of Command Expert did you install?

What operation is taking a long time to run? Opening Command Expert from within Excel, or opening Command Expert outside of Excel?

Does this PC have internet access? If not, is it connected to the a network with no internet access?

Alan Copeland
Command Expert Support

Actions

4 Replies

hognala Apr 26, 2012 3:55 PM
Mark Correct
Correct Answer
Hi Olly

Just to be 100% sure, you don't see the Command Expert ribbon item like in the attached spreadsheet?

What version of Command Expert do you have installed? Is it 1.0 or 1.1? If you have 1.0 installed, I'd recommend that you download and install 1.1 from www.agilent.com/find/commandexpert

When you run the following command at a commandline, does Excel show up in the list?

*reg query HKEY_LOCAL_MACHINE\SOFTWARE\Agilent\CommandExpert\Addons*

I have attached a couple of batch files in the *xp ce excel batch files.zip* file. Do the following to try to install the addin to Excel:

1) Make sure that Command Expert and Excel are closed
2) run *install excel vsto.bat* by double-clicking it
3) does the message say that it installed the addin correctly? If so, can you see Command Expert in Excel now? If not, continue to step 4.
4) Make sure that Command Expert and Excel are closed
5) run *uninstall then reinstall excel vsto.bat* by double-clicking it
6) Does the first message say that it was able to uninstall the addin successfully? If not, post the error message
7) Does the second message say that it was able to install the addin successfully? If not, post the error message
8) Can you see Command Expert in Excel now?
Attachments
- xp ce excel batch files.zip555 bytes
- CommandExpertinExcel.png66.8 KB
Like • Show 0 Likes0
Actions
- ollyt @ hognala on Apr 27, 2012 1:19 AM
  Mark Correct
  Correct Answer
  Hi Hognala,
  
  Thanks for your reply! After following your instructions it has finally appeared! But just for your info....
  
  You are correct in that the Command Expert ribbon was not displaying like in the attached screenshot.
  I am running version 1.1 of Command Expert.
  After running the reg query it returned the following:
  EXCEL REG_SZ
  After running the first batch query you provided (install excel vsto.bat) I opened excel and it appeared :)
  
  Thanks very much for your help, it is much appreciated!
  
  Now I can finally start playing!
  
  Olly
  Like • Show 0 Likes0
  Actions
mikee27tan Aug 30, 2012 5:38 AM
Mark Correct
Correct Answer
Can anybody help here.

I installed command expert on my PC and the Excel add-ins did not appear also
upon running the batch file, the add-in appeared but its kinda taking long to run
around 45 seconds to roughly 2 minutes.

I just downloaded all this and installed it on our Test PC for testing on our
Agilent Devices.

I hope someone could help.
Like • Show 0 Likes0
Actions
- hognala @ mikee27tan on Aug 30, 2012 7:30 AM
  Mark Correct
  Correct Answer
  What version of Excel are you using?
  What OS are you on?
  
  What version of Command Expert did you install?
  
  What operation is taking a long time to run? Opening Command Expert from within Excel, or opening Command Expert outside of Excel?
  
  Does this PC have internet access? If not, is it connected to the a network with no internet access?
  
  Alan Copeland
  Command Expert Support
  Like • Show 0 Likes0
  Actions

Excel Add-on for Command Expert

Outcomes

Attachments

Related Content

Recommended Content

Incoming Links