View Single Post
Old 10-10-2008   #6 (permalink)
Dudely


 
 

Re: How to print a web page with VBA?

Oh wow. Is that really the VBA way to do it? I've never heard of
ExecWB (which means nothing, but) how does one know where to find or
look for something like that in the first place?

Thank you very very much! I'll give it a try.

On Oct 10, 7:19*am, "mayayana" <mayaXXy...@xxxxxx> wrote:
Quote:

> This doccumentation of ExecWB might be useful to people.
> The parameter options are not easy to find.
>
> ExecWB Method
>
> object.ExecWB nCmdID, nCmdExecOpt, [pvaIn], [pvaOut]
>
> object Required. An object expression that evaluates to an object in the
> Applies To list.
> nCmdID Required. A long integer that represents the identifier of the
> command to execute.
> nCmdExecOpt Required. A long integer that represents the options set for
> executing the command.
> pvaIn Optional. A variant used for specifying command input arguments.
> pvaOut Optional. A variant used for specifying command output arguments
>
> ______________
> first parameter - nCmdID options:
> ______________
>
> * * *OLECMDID_OPEN * * * * * * *= 1,
> * * *OLECMDID_NEW * * * * * * * = 2,
> * * *OLECMDID_SAVE * * * * * * *= 3,
> * * *OLECMDID_SAVEAS * * * * * *= 4,
> * * *OLECMDID_SAVECOPYAS * * * *= 5,
> * * *OLECMDID_PRINT * * * * * * = 6,
> * * *OLECMDID_PRINTPREVIEW * * *= 7,
> * * *OLECMDID_PAGESETUP * * * * = 8,
> * * *OLECMDID_SPELL * * * * * * = 9,
> * * *OLECMDID_PROPERTIES * * * *= 10,
> * * *OLECMDID_CUT * * * * * * * = 11,
> * * *OLECMDID_COPY * * * * * * *= 12,
> * * *OLECMDID_PASTE * * * * * * = 13,
> * * *OLECMDID_PASTESPECIAL * * *= 14,
> * * *OLECMDID_UNDO * * * * * * *= 15,
> * * *OLECMDID_REDO * * * * * * *= 16,
> * * *OLECMDID_SELECTALL * * * * = 17,
> * * *OLECMDID_CLEARSELECTION * *= 18,
> * * *OLECMDID_ZOOM * * * * * * *= 19,
> * * *OLECMDID_GETZOOMRANGE * * *= 20
> * * *OLECMDID_UPDATECOMMANDS * *= 21
> * * *OLECMDID_REFRESH * * * * * = 22
> * * *OLECMDID_STOP * * * * * * *= 23
> * * *OLECMDID_HIDETOOLBARS * * *= 24
> * * *OLECMDID_SETPROGRESSMAX * *= 25
> * * *OLECMDID_SETPROGRESSPOS * *= 26
> * * *OLECMDID_SETPROGRESSTEXT * = 27
> * * *OLECMDID_SETTITLE * * * * *= 28
> * * *OLECMDID_SETDOWNLOADSTATE *= 29
> * * *OLECMDID_STOPDOWNLOAD * * *= 30
>
> } OLECMDID;
>
> Elements
> OLECMDID_OPEN
> File menu, Open command
> OLECMDID_NEW
> File menu, New command
> OLECMDID_SAVE
> File menu, Save command
> OLECMDID_SAVEAS
> File menu, Save As command
> OLECMDID_SAVECOPYAS
> File menu, Save Copy As command
> OLECMDID_PRINT
> File menu, Print command
> OLECMDID_PRINTPREVIEW
> File menu, Print Preview command
> OLECMDID_PAGESETUP
> File menu, Page Setup command
> OLECMDID_SPELL
> Tools menu, Spelling command
> OLECMDID_PROPERTIES
> File menu, Properties command
> OLECMDID_CUT
> Edit menu, Cut command
> OLECMDID_COPY
> Edit menu, Copy command
> OLECMDID_PASTE
> Edit menu, Paste command
> OLECMDID_PASTESPECIAL
> Edit menu, Paste Special command
> OLECMDID_UNDO
> Edit menu, Undo command
> OLECMDID_REDO
> Edit menu, Redo command
> OLECMDID_SELECTALL
> Edit menu, Select All command
> OLECMDID_CLEARSELECTION
> Edit menu, Clear command
> OLECMDID_ZOOM
> View menu, Zoom command (see below for details)
> OLECMDID_GETZOOMRANGE
> Retrieves zoom range applicable to View Zoom. (See below for details.)
> OLECMDID_UPDATECOMMANDS
> Informs the receiver, usually a frame, of state changes. The receiver can
> then query the status of the commands whenever convenient.
> OLECMDID_REFRESH
> Asks the receiver to refresh its display. Implemented by the
> document/object.
> OLECMDID_STOP
> Stops all current processing. Implemented by the document/object.
> OLECMDID_HIDETOOLBARS
> View Menu, Toolbars command. Implemented by the document/object to hide its
> toolbars.
> OLECMDID_SETPROGRESSMAX
> Sets the maximum value of a progress indicator if one is owned by the
> receiving object, usually a frame. The minimum value is always zero.
> OLECMDID_SETPROGRESSPOS
> Sets the current value of a progress indicator if one is owned by the
> receiving object, usually a frame.
> OLECMDID_SETPROGRESSTEXT
> Sets the text contained in a progress indicator if one is owned by the
> receiving object, usually a frame. If the receiver currently has no progress
> indicator, this text should be displayed in the status bar (if one exists)
> as with IOleInPlaceFrame::SetStatusText.
> OLECMDID_SETTITLE
> Sets the title bar text of the receiving object, usually a frame.
> OLECMDID_SETDOWNLOADSTATE
> Called by the object when downloading state changes. Takes a VT_BOOL
> parameter, which is TRUE if the object is downloading data and FALSE if it
> not. Primarily implemented by the frame.
> OLECMDID_STOPDOWNLOAD
> Stops the download when executed. Typically, this command is propagated to
> all contained objects. When queried, sets MSOCMDF_ENABLED. Implemented by
> the document/object.
>
> ____________________
> second parameter - *nCmdExecOpt options:
> ____________________
>
> * * OLECMDEXECOPT_DODEFAULT * * * *= 0,
> * * OLECMDEXECOPT_PROMPTUSER * * * = 1,
> * * LECMDEXECOPT_DONTPROMPTUSER * *= 2,
> * * OLECMDEXECOPT_SHOWHELP * * * * = 3
>
> OLECMDEXECOPT_DODEFAULT
> Prompt the user for input or not, whichever is the default behavior.
> OLECMDEXECOPT_PROMPTUSER
> Execute the command after obtaining user input.
> OLECMDEXECOPT_DONTPROMPTUSER
> Execute the command without prompting the user. For example, clicking the
> Print toolbar button causes a document to be immediately printed without
> user input.
> OLECMDEXECOPT_SHOWHELP
> Show help for the corresponding command, but do not execute
My System SpecsSystem Spec