Hi, I would like to know if someone can help me to execute Easymorph and a specific sql consult+extraccion from Excel with vba code.
Could be i suppose:
Thanks a lot in advance
Hi Marc and welcome to the Community!
See this topic on calling Excel VBA macros from PowerShell:
Executing external applications and .bat files in explained here: EasyMorph | Executing external programs
Hi and Thanks
On the first topic i was more thinking about launching a “querry + exls extraccion” project from an excel.xlsm program and then integrate the new data into that excel.xlsm with vba code like:
Sub crearbat()
ruta1 = ThisWorkbook.Path
ruta2 = ruta1 & “\bbdd_prod.xls”
Set fs = CreateObject(“Scripting.FileSystemObject”)
Set a = fs.CreateTextFile(ruta1 & “\extractor.bat”, True)
fini = Split(Sheets(“PARAMETROS”).Cells(10, 2).Value, “/”)
ffin = Split(Sheets(“PARAMETROS”).Cells(11, 2).Value, “/”)
d1 = fini(0) & “/” & fini(1) & “/” & fini(2)
d2 = ffin(0) & “/” & ffin(1) & “/” & ffin(2)
ruta = Split(ruta1, “”)
param00 = “H:”
param01 = "cd " & Right(ruta1, 7)
llam1 = Sheets(“PARAMETROS”).Cells(12, 2).Value
llam2 = Chr(34) & d1 & Chr(34) & " " & Chr(34) & d2 & Chr(34)
llam3 = Chr(34) & ruta2 & Chr(34) & " " & Chr(34) & “marc” & Chr(34)
param2 = llam1 & " " & llam2 & " " & llam3
a.WriteLine param00
a.WriteLine param01
a.WriteLine param2
a.Close
End Sub
Sub extract()
Dim lValDev As Long
ruta1 = ThisWorkbook.Path
ruta10 = ruta1 & “\extractor.bat”
param2 = “extractor.bat”
lValDev2 = ShellExecute(0, “OPEN”, ruta10, param2, “”, 0)
End Sub
I’m not sure I follow you. What’s your question exactly?
To launch easymorph on a second plan from an other application.and close it once the data are collected and extracted to an file in a specific folder
I would like to do it createting and executing a .bat file for example.
The question is what should i write in that .bat file
Thanks
OK, now I understand. Thanks for the clarification. EasyMorph projects can be executed from the command line and .bat files. See this help article for more details: https://help.easymorph.com/doku.php?id=command_line
Hi, Thanks for the info. I have try that command:
morph.exe /c /report bbdd_c28_v3.morph
but windows tell me that it can not find the morph.exe file.
Maybe is because i am still working with the demo version…
Yes, the free edition doesn’t allow running EasyMorph from the command line. You can request a trial key right in the application, on the Start screen. It will be delivered automatically.
