chead5
Active Member
- Joined
- Jun 7, 2004
- Messages
- 356
I'm pretty good with VBA to script internal stuff in Excel. What I need to do is a little out of my scope though, so I thought I would take it to the people.
My company uses MacroMedia's RoboHelp 5x to publish our on-line help files. Periodicly we have to tell robohelp to publish all of our off-line changes up to the webserver. Doing this during business hours can cause an interruption to user access. My office is a 8 to 5 operation but the users of the help topics we generate are here untill about 9 pm. Hence there is a conflict.
We would like to setup windows scheduler to open an excel file after hours, which will trigger the auto-open macro that would then go throught the motions of publishing the help topics. I would envision that we could leave robohelp running and just let excel vba take control of it.
Problem is I have no Idea if this is possible at all. Has anyone had any experience with this?
My company uses MacroMedia's RoboHelp 5x to publish our on-line help files. Periodicly we have to tell robohelp to publish all of our off-line changes up to the webserver. Doing this during business hours can cause an interruption to user access. My office is a 8 to 5 operation but the users of the help topics we generate are here untill about 9 pm. Hence there is a conflict.
We would like to setup windows scheduler to open an excel file after hours, which will trigger the auto-open macro that would then go throught the motions of publishing the help topics. I would envision that we could leave robohelp running and just let excel vba take control of it.
Problem is I have no Idea if this is possible at all. Has anyone had any experience with this?