Microsof Office predefined procedures and functions

GetExCell1 ( row, col, sheet )

This function returns the content of the cell in row and col in the sheet

GetExCell2 ( cell_name, shett )

This function returns the content of the cell in cell_name in the sheet

SetExCell1 ( row, col, cell_value, ftype, width, height, sheet )

This procedure sets the content of the cell in sheet at row and col as cell_value. The ftype must defined ie ftString, ftFloat, ftInteger. The width and height defined in the case the content is a picture.

SetExCell2 ( cell_name, cell_value, ftype, width, height, sheet )

This procedure sets the content of the cell in sheet at cell_name as cell_value. The ftype must defined ie ftString, ftFloat, ftInteger. The width and height defined in the case the content is a picture.

SetExCellComm1 ( row, col, cell_comments, sheet )

This procedure sets the commets of the cell in sheet at row and col as cell_comments.

SetExCellComm2 ( cell_name, cell_commets, sheet )

This procedure sets the comments of the cell in sheet at cell_name as cell_comments.

SetWrdCell ( table_no, row, col, cell_value )

This procedure sets the value of the cell in row and col at table numbered table_no as cell_value. All this action takes place into the active word document.

DisconnectWord ()

This procedure disconnects the word process from the application

DisconnectExcel ()

This procedure disconnects the excel process from the application

FixVarsForWord

OpenWordDoc ( doc_name )

This procedure opens the word document with doc_name (given relatievly from RESOURCES directory)

SaveAsWordDoc

OpenShowWordDoc ( doc_name )

This procedure does the same as the OpenWordDoc except that the document shows to the user.

AppendWordSubDoc

ShowWord ()

This procedure shows to the user the word document that opened using OpenWordDoc.

ShowExcel ()

This procedure shows to the user the excel sheet that opened using OpenExelDoc.

CreateWordDoc

OpenExcelDoc ( doc_name )

This procedure opens the excel sheet with name doc_name. The doc_name contains a full path to the file.

SaveAsExcelDoc

CloseExcelDoc ()

This procedure closes the previously opened excel sheet.

SendVarsToWordDoc ( doc_name )

This procedure sends all the AutoScripts variables from the current content to the doc variables of word named doc_name (based on the same name).

SendVarsToWordDoc1 ( doc_name )

This procedure does the same as the above!