Visual Studio "Automate"

[PWD]

Good afternoon, I've been tasked with converting a Visual Studio project into Excel vba so that my colleagues can be able dive into it, amend or run it, etc.

I think I've most of it down apart from one procedure:-

    Private Sub RunMerlin(ByVal strFNAME As String, ByVal strDIR As String, ByVal strMDIR As String, ByVal strSTPNAME As String, ByVal strData As String)
        FileCopy(strDIR & strFNAME, strMDIR & strData)

        Dim Automate As New Automation

        Automate.Merlin(strMDIR, strSTPNAME, "CE")
        Automate.MTK(strMDIR, "rflag")
    End Sub

I can see the 'FileCopy' part and see what's happening there but it's the 'Automate' parts that have me baffled. There aren't any functions named "Merlin" or "MTK" - in fact this is the only place they appear.

I thought I'd find something "Out There" but I haven't got a clue.

Any ideas? Once I know what it does, I guess I'll be able to figure out have to replicate this in Excel

Many thanks,
D€$

 

[Bluejay07]

I would start by looking at the reference for Automation and see what's associated with it (such as a third party ocx).

If at first you don't succeed, then sky diving wasn't meant for you!

 

[PWD]

OK. I've gone into "Class View" and under "VF_Respond_W7" there's a Class called "Automation". Within this there are entries:-

Merlin(String, String, String)
and
MTK(String, String)

Ah. Lightbulb moment.

Under the 'type' "Automation", as opposed to "General" there is

Public Sub Merlin(ByVal FilePath As String, ByVal Stp As String, ByVal Compilation_Steps As String)

The purpose of which appears to be to check if Merlin is installed. Heck this looks all too weird to continue

Many thanks,
D€$

 

[SkipVought]

you need Arthur's Excalibur. ;-)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[vbajock]

Paste this link into your browser:

http://www.instron.com/wa/library/StreamFile.aspx?doc=724

download manual, refer to page 2-24 on.