VBA Macro not opened from VBScript through Windows Service

Question

I have a windows service that calls VBScript. In VBScript, I have a lot of functions and at the end of all execution I call VBA Macro file. Everything is working as expected, expect calling VBA Macro.

Below is the VBScript code to call VBA Macro file

sub OpenVBAMacroFile ()
   Set xlApp = CreateObject("Excel.Application")
   Set XlBook = xlApp.Workbooks.Open("C:\VBAMacroFile.xlsm")
   xlApp.Run "DataRefresh2"   
   Set xlBook = Nothing
   Set xlApp = Nothing
end sub

When I run VBScript manually, VBA Macro file is opening successfully. But, when I run through Windows service, VBAM Macro file is not opening.

Any help is highly appreciated.

it might help https://stackoverflow.com/a/10232925/7889129 – Maddy May 30 '18 at 10:01 — Maddy, May 30 '18 at 10:01

score 0 · Accepted Answer · answered May 31 '18 at 11:50

0

After a long search, found an answer here

Solution for the issue is to have directory structure c:\windows\syswow64\config\systemprofile\desktop

I do not know how it started working for me. Believe me, this helped for lot of people in the blog

answered May 31 '18 at 11:50

Karthick Raju

757
8
29

VBA Macro not opened from VBScript through Windows Service

1 Answers1