Hi all ,
I have an Standalone application client which pass excel/access file path(absolute) in to EJB server which will convert corresponding excel/access file in to XML.
Till now i have hard-code an excel sheet path in application client but i need to make it to work for any excel sheet.
What i need to accomplish
whenever if an excel sheet opened and saved it should automatically call that application client (by passing current open excel/access absolute path )which will in turn call EJB server to convert in to corresponding XML file format.
How can i retrieve absolute path name of current file(excel/access) whenever save button is clicked ?
I think of using macro and batch files to accomplish this task but when the number of clients increase i think it may become a terrible one.
I'm i right ? or i can use that idea (macro and batch file)?
So give me some ideas how can i accomplish this task .
Thanks in advance