Open Monarch10 and process using.BAT File

Datawatch Monarch 10
September 8, 2016 at 03:42:36
Specs: Windows 7, Dell / 4GB
Hello there,
Appreciate your time in assisting members in their tough time.
Am sure you can help me too please, as I have seen your kind of similar post to my request.

I need a Excel VB Macro to open Monarch10, and open a .txt report and select a model (apply table) and export the final report in excel format and save in a folder.

I have the liberty to use 3 new folder one for each purpose like; Raw Report, Models and Final Report. this way it wont be complicated for you to help me with code and I can amend the share drive path from your reply and test/use the .bat file

path where Monarch10 is installed is : C:\Program Files (x86)\Monarch\PROGRAM\project.xsl

Reason I am looking to automate this process is; as I have 23 reports with 6 model on every given day and I see potential possibilities of increasing in near future too.

Please team, any assistance in this is much appreciated.
Let me know if I need to detail further just in case.

Thanks for your time in replying.
Naresh

message edited by naresh73


See More: Open Monarch10 and process using.BAT File

Report •

#1
January 26, 2017 at 05:46:21
I can't believe this hasn't been responded too earlier...

You want to import a .txt file into excel right?

I can do the following for you for sure:

"I need a Excel VB Macro to open Monarch10, and open a .txt report"

Here is where i need some more info on what exactly you want:

"and select a model (apply table) and export the final report in excel format and save in a folder."

Also uploading the excel file and an example .txt file, then postig the link here will be very helpfull

Simple solutions are often the best

message edited by hidde663


Report •

#2
January 26, 2017 at 10:03:37
Doing a simple google search finds:

https://community.datawatch.com/thr...

https://community.datawatch.com/thr...

The datawatch community would seem to be the place to look.

https://community.datawatch.com/wel...

Also found this;

https://www.experts-exchange.com/qu...


Google is your friend. :-)

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question