Does anyone know a technique Control Robohelp?

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?
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Hi chead5,
I don't know anything about RoBoHelp, so I would be of no use trying to help with any code for your routine (if that's even what you're looking for...) but, I don't think you'd need the Windows scheduler to perform your operation.
If you just use an OnTime macro, that in itself will open up your workbook to execute the code within it. Instead of using the Workbook_Open for your code, (which I guess you could still do if you wanted...), you could put it in a standard module, (named for instance)
Sub RoBoHelpUpdate() ) Then have another routine like:
Sub Update()
Application.OnTime TimeValue("19:30:00"), "RoBoHelpUpdate"
End Sub

I would think that's all you'd need to have it initiate & execute all by itself at 9:30 PM every evening.

Hope it helps,
Dan
 
Upvote 0

Forum statistics

Threads
1,223,460
Messages
6,172,342
Members
452,454
Latest member
MadamRedRabbit

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top