Excel macros to control Java application

[musicgold]

Hi,

Is there a way to create a macro to control a Java-based application interface? I have a Java based application on which I spend a lot of time doing repetitive tasks.
I use Excel based macros to access web pages and download files. I wonder if there is a similar way to have a macro in Excel which can open the Java application and feed the necessary information in its text boxes.

Thanks,

MG.

[xcallmejudasx]

Not sure about excel but you could write a java application to do that. load.exec("command.exe", some text file with the information)

This would require you to write a batch file that changes to the directory the java application is saved and then run it from there. As far as feeding the information to it I'm not sure

[musicgold]

xcallmejudasx,

Thanks. Could you point me to a site where I can read the basics of creating the java application you mentioned?

MG.

[xcallmejudasx]

Do you know Java programming? If not then I wouldn't recommend this option because it may require some complex working.Java 2 Platform SE 5.0 is the class you use to open run a program from within Java. I know you can tell it what file to open using what program but I have no idea if you can also give it extra information and say populate some fields with information on load.

[musicgold]

xcallmejudasx,

Thanks. No, I don't know Java programming.

MG.

[Fubarable]

You might want to try out a windows batch language such as WinBatch. They can help you automate repetitive tasks and since they're built to do this, they're a lot easier to use than Java or to try to shoehorn another language's macros to do something they weren't intended to do.