This project is to update our existing Visual Basic ActiveX control to interface with Word Document macros and fix several quirky Functions such as posting bookmarks automatically inside the current active word document when it gets loaded into IE.
The specs are as follows:
Below has the detail
MSWord IE (v6 /v7) ActiveX Component Control Requirements - Enhancements v 3.0.0
Environment: Visual Basic 6
Component Type: ActiveX Control (CAB)
1. REALTIME REQUEST: Create a new Function to make realtime HTTP request and anchoring the request result back. - NEW
Public Function ProcessRealtime_HTTPRequest(ByVal requestURL As Variant, ByVal sessionKey As String) As String
Where: sessionKey is the IE session identifier that tells the control what active word document it needs to use
requestURL is the HTTP request URL
2. MACROS: Create procedure that can execute a macro into a word document and anchoring any result values (if any) into the provided list of bookmarks. - NEW
Public Sub ProcessRealtime_WordMacro(ByVal sessionKey As String, ByVal macro As Variant, ByVal bookmarkNames As Collection)
Where: sessionKey is the IE session identifier that tells the control what active word document it needs to use
macro is word document macro that needs to execute inside the word document
bookmarkName anchor where if needed by the macro can to anchor its results (values) into.
3. BOOKMARKS: Enhance existing procedure to dynamically attach (anchor) value onto a Word bookmark to an active word document loaded on IE.
Public Sub InsertBookmark(ByVal sessionKey As String, ByVal sBookMark As Variant, ByVal sValue As Variant)
Where: sessionKey is the IE session identifier that tells the control what active word document it needs to use
sBookMark is the bookmark name used as word document anchor
sValue is the bookmark value
4. SERVER SAVE: Enhance existing procedure to do an http post sending encrypted parameter information and the word document content to a Servlet (URL).
Public Sub SendDocToServer(ByVal sessionKey As String, ByVal url As Variant, ByVal params As Variant)
Where: sessionKey is the IE session identifier that tells the control what active word document it needs to use
url is the http/s POST URL where the word document contents (binary) will sent.
params name / value pair that needs to be encrypted and send together with the URL POST
5. PROTECT / UNPROTECT: Enhance existing Protect (lock word document) and Unprotect (unlock word document) procedures. Should have the following options:
4.1 Protect All or Protect Form Only
4.2 Protect with password or Protect without password
Public Sub ProtectDocument(ByVal sessionKey As String, ByVal formProtectSwitch As Boolean, ByVal pwd as String)
Public Sub UnProtectDocument(ByVal sessionKey As String, ByVal formProtectSwitch As Boolean, ByVal pwd as String)
6. SAVE ON PROTECT: Need to do a "SERVER SAVE, see #4) on the word document ONLY on the very 1st time of loading.
The control should be able to recognize if a word document has been loaded on the same IE session (based on the sessionKey) before.
If its the first time loading then do a "SERVER SAVE, see #4. Else do nothing.
THIS NEEDS TO GET DONE IN 4-5 DAYS.