[Solved] Running an Excel macro in Dollar Universe

[Anon Anon]

Hello I have been having a lot of problems running a basic macro via a uproc in Dollar Universe.

there is an exting disccussion thread that is very similar to this:
[url="http://www.orsypforum.com/index.php?showtopic=2860&hl=+excel%20+macro#entry9463"]http://www.orsypforum.com/index.php?showtopic=2860&hl=+excel%20+macro#entry9463[/url]

I have tried this solution but still can't get it to work.

Just to summarise the details:
I have an macro excel macro that I want to be able to run via Dollar Universe as proof of concept.
This macro is called via a VB script similar to that described in the above link.
The VB script command is run from a command script - similar to that described in the above link.
If I run this from the command line it works fine.

At this point, I would try and run this command script via Dollar Universe.
I we get the following error:



C00-SUPPORT-SITE DEBUT
C00-SUPPORT-SITE WSPGM-CODNOEUD DCTWVJMAN05
_!================================================
_!**
$!** PROCEDURE .. : MACRO RUN
$!** VERSION .....: 001
$!** EXECUTION .. : 0000069
_!**
$!** SESSION .... : MACRO SESSION
$!** VERSION .... : 001
$!** EXECUTION .. : 0000001
_!**
_!** PROCESS DATE : 02/27/2013
_!**
_!------------------------------------------------
$!** PARAMETERS. : None
_!------------------------------------------------
_!**  VARIABLES
_!================================================
Microsoft (R) Windows Script Host Version 5.7
Copyright (C) Microsoft Corporation. All rights reserved.

XLRunMacro.vbs started at 11/03/2013 11:22:17
Starting Excel...
Opening file [C:\Applications\Test2.xls]...
ERROR: Microsoft Office Excel: 1004 - Microsoft Office Excel cannot access the file 'C:\Applications\Test2.xls'. There are several possible reasons:

The file name or path does not exist.
The file is being used by another program.
The workbook you are trying to save has the same name as a currently open workbook.
XLRunMacro.vbs stopped at 11/03/2013 11:22:19



I also tried the runas command but via Dollar Univers I keep getting prompted for a password.
Again, this is fine from the command line.

Regards.

Masum Khan

[Anon Anon]

Hi Masum,

my first question will be: are you using the same user in DU as you do from the command line?

Michel

[Anon Anon]

I believe so.
Someone on our service desk raised an issue that the user in Dollar Universe is detached from Active Directory & this may be the reason why the marcro isn't running.
If I understand correctly - even though it is the same user, it may not be recognised as such.

Masum

[Anon Anon]

Hi,

I have no insight on this specific aspect. I guess ORSYP Support would be able to answer.

Can you double check it is the same user - irrespective of the LDAP aspect?

Can you also check if the related windows service can interact with the desktop?

Michel

[Anon Anon]

I have forward your question onto our servide desk.
This is their response after having sat down and gone through this issue with me:

[i]This has been checked and works! The issue is with the tool and the way it integrates with our environment[/i]

[Anon Anon]

Hi Masum,

Sorry but what does this mean exactly? [size=4]What has been checked and works? [/size]

[size=4]If it is that it works out of DU you and I know that, but it does not answer any of the questions we asked. The issue may be in the way they have configured it and we need to make sure.[/size]

[size=4]OK?[/size]

[size=4]Michel[/size]

[Anon Anon]

Hi Men

We have tried running the script interactively on the remote computer and by using a scheduled task to execute the script remotely. both of these methods were successful for us! (when I say successful i mean excel and the macro are launched with the expected output)

I agree with your statement "[size=3][i]If it is that it works out of DU you and I know that, but it does not answer any of the questions we asked. The issue may be in the way they have configured it and we need to make sure.[/i][/size]" However we arent sure what you mean by "configured" in terms of LDAP, we believe this works as expected as our Enterprise team have successfully tested this functionality and as for the service there are no group policies in place restricting the service as far as we are aware.

Would it be possible to schedule a webex session to have this issue investigated as a priority!

Please advise

Masum & Zaheer

[Anon Anon]

Hi Masum (& Zaheer),

I would then recommend you open a ticket at Support - here we are not equipped to handle your request.

Open the ticket, provide them with the result of an uxtrace of the DU node, with the Uproc script, with the Uproc job log (make sure it is verbose enough so they can see what is happening, add "echo on" commands if necessary) and any other relevant information.

Then post the ticket number here so I can follow up with my Support colleagues.

Michel

[Anon Anon]

hi guys,

have you opened the case? Number?

Michel

[Anon Anon]

[quote name='men' timestamp='1365072585' post='15301']
hi guys,

have you opened the case? Number?

Michel
[/quote]

I believe it is ca122879[img]http://customer.orsyp.com/s.gif[/img]

[Octavie_Chakoute_1958]

Hi MattH,

It seems that Support provided you with the following solution and is waiting for your feedback:


[quote]-Create a folder called Desktop in %WINDIR%\SysWow64\Config\SystemProfile

-The submission user must be log on as "Local System" with interactive checked.

-Launch the the same uproc.[/quote]


[font=Arial]Could you perfom the step above?[/font]

[font=Arial]Octavie[/font]

[Anon Anon]

[quote name='8ie' timestamp='1365691450' post='15420']
Hi MattH,

It seems that Support provided you with the following solution and is waiting for your feedback:





[font=Arial]Could you perfom the step above?[/font]

[font=Arial]Octavie[/font]
[/quote]

This didn't work. I have managed to move this forward a little so that it is isolated to security with our environment or AD. I have managed to get this working when the account used is my AD user but it doesn't when it is a domain admin or service account. Therefore the issue is currently with our enterprise team.

Thanks

[Anon Anon]

Hi MattH,

have you/they been able to move on?

Michel

[Anon Anon]

Hi Michel,

I had to pass this on to someone that had greater permissions in our environment to follow up. Unfortunately they haven't had time yet but I believe they should do soon.

Thanks,

Matt

[Mark Gliessner]

Hello,

I know this is a little late to chime in on this subject, but we have successfully ran a Windows scheduled task via Dollar Universe by using the below command. Since you were able to run this process via a scheduled task, you may want to try this in your Uproc script.

Schtasks /Run /TN taskname

Windows has some controls in place to not allow certain calls on functions within Office products (I.e PDF conversions in/out of Word) I would make a guess that an Excel macro falls into this category based on what you are experiencing.

Here is a link to a greater reference to Schtasks.exe:

[url="http://msdn.microsoft.com/en-us/library/windows/desktop/bb736357(v=vs.85).aspx"]http://msdn.microsoft.com/en-us/library/windows/desktop/bb736357(v=vs.85).aspx[/url]

Regards,

Mark

[Octavie_Chakoute_1958]

Hello Mark,

Thanks for your valuable input. It will for sure help more than one.

Octavie

[Anon Anon]

FYI, this issue was resolved. It turned out it was related to how the account was created in DU, being a Windows system user rather than Other.

[Octavie_Chakoute_1958]

Hello Matt,

Thanks for your feedback and confirmation.

Have a great day!

Octavie