Does anyone know an easy way to automatically run excel from windows?
I'm working on something in excel vba that I would like to run automatically from a windows service folder change event.
Our Oracle security policies are setup such that no scripting can pass into Oracle and retrieve data. I'd like to limit our interaction to: request this "op installation" report, let it finish running and click "view output".
What happens when you click "view output" is Oracle saves a txt file with the data in an ie temp folder and opens it in internet explorer. I want to write a windows service that watches the folder, and when Oracle writes the data file, it launches excel and a .xslm file.
I think I can handle the windows service--I've done that before, but I don't know how to handle interfacing into excel and opening a file.
Anyone know an easy way to do this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks