Auto-Run macros failing

nb.
I have also asked this question on a sql server forum in case it is sql server related, but please help if this is an Excel issue.



I have a script (vb) that I use to open up an excel workbook, when I double click the script it opens the excel workbook and runs the macros which are set to auto-run within it all run Ok.

Now when I try to run the the same script through sql server using xp_cmdshell, the script runs and opens the workbook (I can see this happening in windows explorer), but the macros within the workbook do not run?
The last command to run should be to close the workbook, but it doesn't even run the first command (i've checked for the changes that should happen)

I have enabled the macros in excel (enable all macros),
also I have checked the box to 'Trust to the VBA project object model',
also I have set the folder which the xlsm file is in to be a trusted location,
also I have set the activeX settings to 'Enable all controls'

Yet the macros only will run when I double click the vb script file myself!

I am stumped on this and have been stuck on it for days now, can anyone help or suggest where I could get help to resolve this as it needs to be done quickly.

Thanks for the replies,
@romperstomper
never thougt of that one - cheers, will use that in future.

@royUK
it's vbs.


All working now, found the fault to be with using a local path to the files when running the script on the server would work OK (N:\path\file) , but when firing it up from elsewhere I had to change it to a virtual path to get it to run (\\servername\path\file)

In my testing I was using local path as I was working on the server itself, but had to change this over to a virtual path once testing externally to the server.