Macro for executing commands from cmd prompt

[nemadedurgesh]

Macro for executing commands from cmd prompt




I need to run a batch from command prompt. It has exe file as well. My moto is to activate exe as schedule run. Below are the problem which I am facing due to which I need a macro to be created. Any of the resolution can solve my problem.


This batch works fine when I directly double click on exe and start it. Also is works fine when manually trigger from command prompt.


Brief idea of Batch - When I double click on batch exe, one csv file is created at given location, ertract all information in string from application and save it in created csv file.


I have tried below three approach and issue is that batch is triggered but csv file if not triggered at the start which causes to fail this batch


approach 1 - when I call exe file by "schedule task"
approach 2 - When I call exe file from macro without using cmd
approach 3 - when I call exe file using macro with cmd


Below is the code I have created. Please suggest


Sub Workbook_Open()

Call Shell("cmd.exe /S /K" & "E:\Users\x9nemd\Desktop\R2_Utility\TfsDataExport.exe", vbNormalFocus)
MsgBox ("Extract Run Activated")


End Sub

 

[JLGWhiz]

The workbook_open event procedure needs the word Private included and it must be installed in the ThisWorkbook code module. Press Alt + F11 to open the VB editor, then double click on "ThisWorkbook" in the small Projects pane at upper left of the large code pane. When you see [ThisWorkbook(Code)] at the top margin of the VB editor window, paste your code into the large code pane and click the 'Save' icon. Close the file and reopen it and your code should run.

Private Sub Workbook_Open()

As written, you message box will not appear until yourbatch file has executed.

 

[nemadedurgesh]

No Success... Still same problem

 

[John_w]

Cross-posted - please posts link(s) to your threads on other forums.