locked
App-V Sequencer and VBA RRS feed

  • Question

  • Trying to sequence Dynamics GP 10 on Server 2008 R2 x64 using App-V 4.6.20200. The actual application installs and sequences fine. But the company this is being implemented for has custom VBA forms and when i go to import the Forms through GP it complains that it cannot initialize VBA. I also cannot launch the VB editor from GP while sequencing as well. It works when installing outside of the sequencer.

    I noticed that the key : HKLM\SOFTWARE\Wow6432Node\Microsoft\VBA uses short names and i believe this to be the problem. I can't find any info on what to do to resolve this (aside from changing that registry value)

    Monday, August 2, 2010 8:33 PM

Answers

  • So the solution to this is kind of an odd solution:

    Prior to launching the sequencer open Word then open the VB Editor from there and create a blank macro then close the vb editor and word without saving anything.

    • Marked as answer by Bryan Sprowls Friday, October 15, 2010 1:19 AM
    Friday, October 15, 2010 1:19 AM

All replies

  • Ok so just to see if i could verify whether this was it i set the registry key using the long names and it was a no-go.
    Monday, August 2, 2010 8:40 PM
  • What the values are being set in the key?
    Monday, August 2, 2010 9:30 PM
    Moderator
  • This is what is set in the Key:

    [HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\VBA]
    "Vbe6DllPath"="C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL"

    Here's the procmon xml output for the dynamics.exe when i try to do the module import during the monitoring phase of sequencing. Not sure what a lot of these keys are. But i'm going to check if they exist when the app is installed outside of the sequencer. If you have any ideas feel free to let me know.

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:35.0333982 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\WindowsForms10.Window.8.app.0.33c0d9d</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:35.0337067 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\TNT</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.4512917 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\WindowsForms10.Window.8.app.0.33c0d9d</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.4515830 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\TNT</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.5923572 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\WindowsForms10.Window.8.app.0.33c0d9d</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.5926563 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\TNT</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.5933523 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\WindowsForms10.Window.8.app.0.33c0d9d</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.5936482 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\TNTDLG</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.5946522 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>QuerySecurityFile</Operation>
    <Path>Q:\GreatPlains\GP\Dynamics.vba</Path>
    <Result>BUFFER OVERFLOW</Result>
    <Detail>Information: Owner, Group, DACL</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.5949772 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryKey</Operation>
    <Path>HKLM</Path>
    <Result>BUFFER OVERFLOW</Result>
    <Detail>Query: Name, Length: 4</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.6112547 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryKey</Operation>
    <Path>HKLM</Path>
    <Result>BUFFER OVERFLOW</Result>
    <Detail>Query: Name, Length: 4</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.6138137 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryKey</Operation>
    <Path>HKLM</Path>
    <Result>BUFFER OVERFLOW</Result>
    <Detail>Query: Name, Length: 4</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.6162052 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegOpenKey</Operation>
    <Path>HKCU\Software\Classes\Wow6432Node\CLSID</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Desired Access: Read</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.6162241 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegOpenKey</Operation>
    <Path>HKCU\Software\Classes\Wow6432Node</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Desired Access: Query Value</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.6162362 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegCreateKey</Operation>
    <Path>4쀀</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Desired Access: Query Value</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.6165015 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegOpenKey</Operation>
    <Path>HKCU\Software\Classes\Wow6432Node\CLSID</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Desired Access: Read</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.6165185 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegOpenKey</Operation>
    <Path>HKCU\Software\Classes\Wow6432Node</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Desired Access: Query Value</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.6165299 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegCreateKey</Operation>
    <Path>4쀀</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Desired Access: Query Value</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.6167507 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegOpenKey</Operation>
    <Path>HKCU\Software\Microsoft\Dynamics GP\9.0\SQM</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Desired Access: Query Value, Enumerate Sub Keys</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.6167725 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegOpenKey</Operation>
    <Path>4쀀</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail></Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.6173722 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\WindowsForms10.Window.8.app.0.33c0d9d</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.6177056 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\TNT</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.6220819 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\WindowsForms10.Window.8.app.0.33c0d9d</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.6223735 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\TNT</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.6230773 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\WindowsForms10.Window.8.app.0.33c0d9d</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:37.6233780 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\TNTDLG</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:39.7817252 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\WindowsForms10.Window.8.app.0.33c0d9d</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:39.7820093 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\TNTDLG</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:39.9356765 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\WindowsForms10.Window.8.app.0.33c0d9d</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:39.9359438 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\TNTDLG</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:39.9368972 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\WindowsForms10.Window.8.app.0.33c0d9d</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:39.9372294 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\TNT</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:42.2785197 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\WindowsForms10.Window.8.app.0.33c0d9d</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    <event>
    <ProcessIndex>493</ProcessIndex>
    <Time_of_Day>9:21:42.2788182 PM</Time_of_Day>
    <Process_Name>Dynamics.exe</Process_Name>
    <PID>1444</PID>
    <Operation>RegQueryValue</Operation>
    <Path>HKLM\Software\Wow6432Node\Microsoft\CTF\KnownClasses\TNT</Path>
    <Result>NAME NOT FOUND</Result>
    <Detail>Length: 0</Detail>
    </event>

    Tuesday, August 3, 2010 3:26 AM
  • Hello,

    Is the file available?

    /Znack
    Tuesday, August 3, 2010 4:06 PM
  • Which file?
    Tuesday, August 3, 2010 4:33 PM
  • Hello,

    The only file mentioned;

    C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL

    Is it available via that path?

    /znack

    Tuesday, August 3, 2010 4:37 PM
  • Yes, i can open explorer and paste in the path to the file and get the file.
    Tuesday, August 3, 2010 4:47 PM
  • Is that from the virtual environment or the native environment?

    /Znack
    Wednesday, August 4, 2010 4:27 PM
  • So the solution to this is kind of an odd solution:

    Prior to launching the sequencer open Word then open the VB Editor from there and create a blank macro then close the vb editor and word without saving anything.

    • Marked as answer by Bryan Sprowls Friday, October 15, 2010 1:19 AM
    Friday, October 15, 2010 1:19 AM
  • Got a 1004 VBA error with Excel 2003 addon (XLA file). Excel couldn't find (correct) VBA version that came with Office 2003(2010 installed locally). Changed path in registry to point directly to Q:\assetdir\VFS\...

    Another ancient app to live on.

    Procmon threw a Not found on the vbe6.dll.

    Saturday, November 1, 2014 11:09 AM