06-17-2005, 08:26 PM
Ginteras,
Thanks for sticking with me through this - I take it you need a general functional desription.
Procedure
1. If the "RD" file is open as a window, then put filename into a file called heehaw.txt.
2. Call a Word macro to use the file dialog method to get the filename
3. Run a Word macro which reformats the "RD" file to an "SR" file
4. QM opens both RD and SR files (horizontally tiled) and runs a macro which highlights any errors in the RD file
Notes:
The Word macros are set up in the Word main menu bar, however, if there were a way of calling them directly i.e. normal.XMLLib.FileDialog that would be better. Alternatively - do I have to produce a dialog window at the start and end of every Word macro which I would use to synchronize processing?
Thanks, Bob
CheckNOpen Macro
Program wriiten 04-may-05 by Bob Arnold
Inputs
Open "RD" window
File dialog prompt
Outputs
d:\heehaw.txt containing
"RD" file name selected
d:\gobble.txt containing
full "RD" file name selected
SR report file
d:\errmsg.txt containing
error message from report processing if error occurs
d:\errcontext.txt containing
error context from report processing if error occurs
error highlighted in RD file if error occurs
Description
If an "RD" file is open then run the Reporter and re-display files
Else select file from file open dialog run Reporter and re-
display files
Pseudocode
if RD window open get full filename, run report and re-display
else prompt for file name, run report and re-display
Called by
QB
Calls
OneOpener (Microsoft Word)
Thanks for sticking with me through this - I take it you need a general functional desription.
Procedure
1. If the "RD" file is open as a window, then put filename into a file called heehaw.txt.
2. Call a Word macro to use the file dialog method to get the filename
3. Run a Word macro which reformats the "RD" file to an "SR" file
4. QM opens both RD and SR files (horizontally tiled) and runs a macro which highlights any errors in the RD file
Notes:
The Word macros are set up in the Word main menu bar, however, if there were a way of calling them directly i.e. normal.XMLLib.FileDialog that would be better. Alternatively - do I have to produce a dialog window at the start and end of every Word macro which I would use to synchronize processing?
Thanks, Bob
CheckNOpen Macro
Program wriiten 04-may-05 by Bob Arnold
Inputs
Open "RD" window
File dialog prompt
Outputs
d:\heehaw.txt containing
"RD" file name selected
d:\gobble.txt containing
full "RD" file name selected
SR report file
d:\errmsg.txt containing
error message from report processing if error occurs
d:\errcontext.txt containing
error context from report processing if error occurs
error highlighted in RD file if error occurs
Description
If an "RD" file is open then run the Reporter and re-display files
Else select file from file open dialog run Reporter and re-
display files
Pseudocode
if RD window open get full filename, run report and re-display
else prompt for file name, run report and re-display
Called by
QB
Calls
OneOpener (Microsoft Word)
