Hi guys - just in case someone is interested in DDE/Office connectivity, here is a list of usefull DDE commands for MS-Word and Excel (2000,XP,....) which I found on the internet....

If you know of any which are not listed here, it would be great if you could email me them - THANKS - Hubert

###############################################################
MS-Word
###############################################################
(DdeExecute) Command    Description
[FileNew]    Creates a new empty document
[FileNew .NewTemplate = 0, .Template = Template$]    Creates a new document or template.NewTemplate =    0 (or omitted) = new document        1 New template.Template = The name of the template or document on which to base the new document or template, or the name of the wizard to run. You *must* specify the complete path to the template file.
[FileSaveAs „c:\temp\test.doc", 0]    Save active document as "c:\temp\test.doc"
[FileSave]    Save active document
[FileClose]    Close active document
[FileExit Mode]    Quits Winword. Mode:0   Prompts the user to save documents1   Saves all edited documents before quitting.2   Quits without saving changed documents.
[FilePrintDefault]    Prints the active document using the current settings in the Print and Print Setup dialog boxes (File menu) and on the Print tab in the Options dialog box (Tools menu).
[InsertPicture("c:\pic1$$$$.bmp")]    Inserts picture file at current cursor position
[Insert("Hello")]    Inserts text "Hello"
[Insert "Hi HTBasic users"]    Inserts text "Hi HTBasic users"
[InsertFrame]    Inserts an empty frame, or frames the selected text, graphic, or both. If there is no selection, Word inserts a 1-inch - square frame at the insertion point (the frame appears as a square in page layout view). You can change the dimensions of the frame with FormatFrame.
[RemoveFrames]    Removes all frames in the selection. Note that borders, applied automatically when you insert a frame around text, are not removed.
[FormatBordersAndShading.Shadow=1,.TopBorder=1, .LeftBorder=1, .BottomBorder=1, .RightBorder=1, .ApplyTo=0]    Sets border and shading formats for the selected paragraphs, table cells, or graphic. The arguments for the FormatBordersAndShading statement correspond to the options in the Borders And Shading dialog box (Format menu)..Shadow  Specifies whether to apply a shadow to the border of paragraphs or a graphic:0 (zero)    Does not apply a shadow.1  Applies a shadow.You cannot apply a shadow to a table or table cells. If you want to apply a shadow to a paragraph or graphic, the item must have---or you must specify---matching right, left, top, and bottom borders. Otherwise, an error occurs..TopBorder, .LeftBorder, .BottomBorder, .RightBorder  The line style for the border on the top, left, bottom, and right edges of paragraphs, cells, or a graphic, in the range 0 (zero), which is no border, through 11 (for a list of line styles and their values, see BorderLineStyle)..ApplyTo  If the selection consists of more than one of the following items, specifies to which item or items the border format is applied:0 (zero)    Paragraphs1    Graphic2    Cells3    Whole tableIf .ApplyTo is omitted, the default for the selection is assumed..TopColor, .LeftColor, .BottomColor, .RightColor, .HorizColor, .VertColor    The color to be applied to the specified borders, in the range from 0 (zero), which is Auto, through 16 (for a list of colors and their values, see CharColor).
[InsertBreak.Type=x]    Inserts a break. .Type values:0   (zero) or omitted    Page break1   Column break2   Next Page section break3   Continuous section break4   Even Page section break5   Odd Page section break6   Line break (newline character)
[InsertDateTime .InsertAsField = number]    Inserts the current date, time, or both, as either text or a TIME field. .InsertAsField    Specifies whether Word inserts the information as a TIME field:0 (zero)    Word inserts the information as text.1   Word inserts the information as a TIME field.Omitted    Word inserts the information according to the current setting of the Insert As Field check box in the Date And Time dialog box (Insert menu).
[InsertPageNumbers .Type = 0, .Position = 2, .FirstPage = 0]    Inserts page number into the header or footer..Type: 0 = header, 1= footer.Position: 0 = Left, 1=Center, 2=Right3=Inside (left on odd pages, right on even pages)4=Outside (right on odd pages, left on even pages).Firstpage: If 1, the field is included in the header or footer on the first page.
[TableInsertTable .NumColumns = 3, .NumRows = 5, .Format=xx]    Inserts a table with .NumColumns columns and .NumRows rowsAdditional parameter: .Format=xxwhere xx = One of the predefined formats listed in the Table AutoFormat dialog box (Table menu): 0 (zero) corresponds to the first format listed in the Formats box ("none"), 1 corresponds to the second format, and so on.
[TableDeleteColumn]    Deletes the table column containing the insertion point, or deletes all columns containing part of the selection. If the insertion point or selection is not within a table, an error occurs.
[TableDeleteRow]    Deletes the row containing the insertion point, or deletes all rows containing part of the selection. If the insertion point or selection is not within a table, an error occurs.
[TableDeleteCells .ShiftCells = number]    Deletes the selected cells. If the insertion point or selection is not within a table, an error occurs..ShiftCells: Sets the direction to shift the remaining cells:0 (zero)    Shift the cells left.1    Shift the cells up.2    Delete the entire row.3    Delete the entire column.
[TableSelectTable]    Selects the entire table containing the insertion point. If the insertion point or selection is not in a table, an error occurs. As the examples in this entry demonstrate, you can use TableSelectTable in combination with other WordBasic statements to move the insertion point reliably to the first cell in a table or to the first character after a table.
[InsertPara]    Inserts a paragraph mark at the insertion point.
[Bold][Bold 1][Bold 0]    Toggles bold stateSwitches on Bold stateSwitches off Bold state
[NextCell][PrevCell]    Selects the contents of the next table cellSelects the contents of the previous table cell
[Underline][Underline 1] & [Underline 0]  see above    Toggles underline state
[Italic][Italic 1] / [Italic 0] see above    Toggles italic state
[DottedUnderline][DottedUnderline 1] / [DottedUnderline 0] see above    Toggles dottedunderline state
[DoubleUnderline][DoubleUnderline 1] / [DoubleUnderline 0] see above    Toggles dottedunderline state
[FormatFont("15")]    Sets font size to 15 points
[Font("Arial")]    Selects font "Arial"
[CharColor x]    Sets color of characters to value x. Range: 0..16Values0=Auto, specified in the Control Panel (Windows)1=Black, 2=Blue, 3=Cyan, 4=Green, 5=Magenta, 6=Red, 7=Yellow, 8=White, 9=Dark Blue, 10=Dark Cyan, 11=Dark Green, 12=Dark Magenta, 13=Dark Red, 14=Dark Yellow, 15=Dark Gray, 16=Light Gray
[ResetChar x]    0 (zero)    If the selected text contains any manual     character formatting1    If the selected text contains no manual     character formatting
[NormalStyle]    Applies the Normal style to the selected paragraphs
[Style Style$]    Applies a style to the selected paragraphs.Example: [Style "Heading 1"]
FormatStyle .Name = "TestMe", .DefineFormatDefineStyleFont .Points = "10", .Bold = 1, .SmallCaps = 1    .Name    The name of the style..Delete    Deletes the specified style..BasedOn  Specifies an existing style on which to base the specified style..Type    specifies the type for a new style,:    0 (zero) or omitted    Paragraph    1 Character.FileName  The document or template to merge styles to or from..Define    Redefines an existing style or creates a new  style with the formats specified in subsequent instructions..Rename  Renames the style specified by .Name to the name specified by .NewName..Apply    Applies the style to the selected paragraphs.
[FormatPicture .ScaleX = ""50%"", .ScaleY = ""50%""]    Formats a picture using the values .ScaleX and .ScaleY. You must select the picture before you can do this formatting, e.g. using [editgoto .Destination="G2"]   ! go to picture 2[charright 1,1]  ! select the pitcure
[LeftPara]    The LeftPara statement aligns the selected paragraphs with the left indent.
[RightPara]    The RightPara statement aligns the selected paragraphs with the right indent.
[CenterPara]    Centers the selected paragraphs.
[JustifyPara]    The JustifyPara statement justifies the selected paragraphs.
[LineUp]    Cursor 1 line up
[LineDown]    Cursor 1 line down
[CharLeft]    1 character left
[CharRight]    1 char right
[EditSelectAll]    Selects whole document
[EditGoto]    Jumps to start of document
[EditGoto .Destination="Bookmark1"]    Jumps to "Bookmark1"
[EditGoto .Destination="L6"]    Jumps to line 6 on current page
[EditGoto .Destination="L+2"]    Relative jump to the 2nd line after the current line
[EditGoto .Destination="L-1"]    Relative jump to the previous line
[EditGoto .Destination="S3"]    Jumps to section 3 on current page
[EditGoto .Destination="P5"]    Jumps to page 5
[EditGoto .Destination="F’TIME"]    Jumps to next field called TIME
[EditGoto .Destination="T2"]    Jumps to table 2
[EditGoto .Destination="G7"]    Jumps to graphic 7
[EditGoto .Destination="Q4"]    Jumps to equation 4
[FilePrintPreview]    Printer Preview
[ViewNormal]    "Normal" page view
[ViewPage]    "Page Layout" view
[EditUndo]    Undo last action
[EditRedo]    Redo last action
[EditPaste]    Paste data from clipboard
[EditCut]    Cut selected data to clipboard
[EditCopy]    Copy selected data to clipboard
[DeleteWord]    Deletes the word immediately following the insertion point
[DeleteBackWord]    Deletes the word immediately preceding the insertion point
[EditClear clear]    Deletes the selection or a specified number of characters. If clear is > 0 the appropriate number of characters to the right of the insertion point will be deleted. If clear is < 0 the appropriate number of characters to the left of the insertion point will be deleted.
[EndOfDocument]    Jumps to the last line of the document
[EndOfLine]    Jumps to the end of the current line
[EndOfLine 1]    Marks text from current cursor position to the end of the line
[StartOfLine]    Jumps to the begin of the current line
[StartOfLine 1]    Marks text from current cursor position to the begin of the line
[EndOfDocument 1]    Marks text from current cursor position to the end of the document
[StartOfDocument 1]    Marks text from current cursor position to the begin of the document
[EndOfWindow]    Marks current page content
[CharRight 1,1]    Marks next character
[CharRight 5,1]    Marks next 5 characters
[CharLeft 1,1]    Marks previous character
[CharLeft 3,1]    Marks previous 3 characters
[WordRight 1,1]    Marks next word
[WordRight 8,1]    Marks next 8 words
[WordLeft 1,1]    Marks previous word
[WordLeft 2,1]    Marks previous 2 words
[VLine x]    Scrolls the document xx lines (x>0 = scroll down, x<0 scroll up)
[VPage x]    Scrolls the document xx screens (x>0 = scroll down, x<0 scroll up)
[FormatBullet.Indent=5,.Font="Fontname",.CharNum=xx, .Points=10]    Adds bullets to the selected paragraphs..Points    The size of the bullets, in points..Color    The color of the bullets.CharNum    The sum of 31 and the number corresponding to the position of the symbol in the Symbol dialog box (Insert menu), counting from left to right. For example, to specify an omega (), which is at position 56 on the table of symbols in the Symbol font, set .CharNum to 87..Font    The name of the font containing the symbol. Names of decorative fonts appear in the Font box in the Symbol dialog box.
[ToggleFull]    Toggles full screen mode on and off.
[ViewZoom100]    Switches to normal view and sets magnification to 100 percent for the active document and new documents.
[ViewZoomWholePage]    Sets magnification so the entire page is visible in page layout view. ViewZoomWholePage switches to page layout view if the active document is in another view.
[AppMinimize]    Minimizes Word application window
[AppMaximize]    Maximizes Word application window
[AppRestore]    Restores Word application window
[AppHide]    Hides Word application window from task bar
[AppShow]    Shows Word application window (after hiding)
[AppActivate]    Brings Word application window to front

###############################################################
EXCEL
###############################################################
(DdeExecute) Command    Description
[Open("filename")]    Opens the file specified by "filename"
[File.Close(0)]    Closes the active file (file will *not* be saved)
[File.Close(1)]    Closes the active file (file will be saved)
[File.Delete("filename")]    Deletes the file "filename" without user prompt
[File.Delete?("filename")]    Deletes the file "filename" with user prompt
[New(1)]    Creates a new file
[Save.As("c:\test.xls")]    Saves active sheet as "c:\text.xls"
[Save]    Saves changes
[INSERT]    Pastes the the clipboard text at the current position
[COPY]    Copies the current selection to the clipboard
[PRINT]    Prints the current area
[SHOW.INFO(logical)]    Shows (1) info about the current cell or hide it (0)
[ZOOM(magnification)]    Zooms document according to magnification (10 .. 400)
[RUN("Makro2")]    Executes the Excel macro "Macro2"
[APP.ACTIVATE]    Brings Excel to the front (input focus)
[APP.MAXIMIZE]    Maximizes Excel
[APP.MINIMIZE]    Minimizes Excel
[APP.RESTORE]    Restores Excel window
[APP.SIZE(x,y)]    Set the new size for the Excel window to x,y
[APP.MOVE(x,y)]    Moves the Excel window
[FULL.SCREEN(logical)]    Switches between full screen (1) and normal view (0)
[A1.R1C1(logical)]    Logical    is a logical value specifying which reference style to use. If logical is 1, all worksheets and macro sheets use A1 references; if 0, all worksheets and macro sheets use R1C1 references.
[WORKBOOK.INSERT(1)]    Inserts an additional sheet (Tabelle/Blad)
[WORKBOOK.INSERT(2)]    Inserts sheet containing a chart
[WORKBOOK.ACTIVATE("sheetname")]    Activates the workbook named "sheetname"
[WORKBOOK.NEXT]    Activates the next workbook
[WORKBOOK.PREV]    Activates the previous workbook
[WORKBOOK.NAME("old_name","new_name")]    Renames the workbook from "old_name" to "new_name". Note:  To rename a workbook properly you have to use a certain sequence of commands. Click here for a detailed example.
[Font.Properties("Arial","Bold","15";;;;;;;"3")]    Sets the font properties to "Arial, 15 point bold"
[Font.Properties?()]    Displays the font properties dialog
[WINDOW.RESTORE]    Restores window size and position
[WINDOW.MAXIMIZE]    Maximizes current window
[WINDOW.MAXIMIZE("ts.xls")]    Maximizes window "ts.xls"
[WINDOW.MINIMIZE]    Minimizes current window
[WINDOW.MINIMIZE("ts.xls")]    Minimizes window "ts.xls"
Variants of the "New" command:   
[New(1,1)]    Creates new sheet with one map
[New(2,1)]    Creates diagram from current selection
[New(3,1)]    Creates macro
[New(4,1)]    Creates macro
[New(5,1)]    Creates sheet with 16 tables
[New(6,1)]    Creates module
[New(7,1)]    Creates dialog
(German version)

(DdeExecute) Command    Description
[SYMBOLLEISTE.ZEIGEN(5;WAHR)]    Shows toolbar "Zeichnen"
[WINDOW.MINIMIZE("ts.xls")]    Minimizes window "ts.xls"
[AUSWÄHLEN("Z1S1:Z6S3")]    Selects Row 1:Col 1 to Row 6:Col 3
(German version)

(DdeRequest) Command    Description
DdeRequest(Ch,"Z1S1",Sel$,Rs)    Returns the content of Z1S1 (Zeile 1 Spalte 1)
DdeRequest(Ch,"Selection",Sel$,Rs)    Returns the selected Topic, e.g.:Sel$="[Mappe1]Tabelle1!Z1S3"
(All 16 Bit and 32 Bit English versions and all 32 Bit international versions)

(DdeRequest) Command    Description
DdeRequest(Ch,"R1C1",Sel$,Rs)    Returns the content of R1C1 (Row 1 Column 1)
DdeRequest(Ch,"Selection",Sel$,Rs)    Returns the selected Topic, e.g.:Sel$="[Book1]Sheet1!R1C3"
(All 16 Bit and 32 Bit English versions and all 32 Bit international versions)

(DdeExecute) Command    Description
[SELECT("R1C1:R6C3")]    Selects Row 1:Col 1 to Row 6:Col 3

Hubert Hoelzl
Sales & Marketing Director Querix Ltd
_____________________________________________________________
Querix International Distribution:
Querix, z.H. Hubert Hoelzl, Ahornweg 2, 85464 Neufinsing, Germany
Tel: +44 2380 385 187 or +44 2380 232345 or +49 8121 429621   Fax: +44 2380 399 685  
Email: h.hoelzl@querix.com   Web: www.querix.com
_____________________________________________________________
Privileged/Confidential Information and/or Copyright Material may be contained in this e-mail.
The information and Material is intended for the use of the intended addressee and only in good faith.
If you are not the intended addressee, or the person responsible for delivering it to the intended addressee, you may not copy, re-produce or deliver it to anyone else or use it in any unauthorised manner.
To do so is prohibited and may be unlawful. If you receive this e-mail by mistake, advise the sender immediately by using the reply facility in your e-mail software.
Also, the views expressed in this document do not necessarily represent those of the management of QueriX (UK) Ltd.
Specification and prices are subject to change without notice. All trademarks & copyrights acknowledged.

Contact:     Company:Private -HH- Mail Merge Contacts  Email Address: informix-list@iiug.org ContactID: N/A - CompanyID: 9900

sending to informix-list