Do not let any software impress you!

Only let it convince your intellect.
Slider img 1
Do not look for a business paradise!

It is a waste of time.
Slider img 2
Only yourself can push you uphill.

There is no easy road to prizes.
Slider img 3
Productivity is the name of the game.

And you have to conquer it.
Slider img 4
As long as you understand it,

you will start to build your know-how.
Slider img 5
We can help with that.

We have the tools and the method.
Slider img 6

Microsof Office related 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 the sheet at a row and col as cell_value. The ftype must be defined, i.e., ftString, ftFloat, ftInteger. We define the width and height 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 the sheet at cell_name as cell_value. The ftype must be defined, i.e., ftString, ftFloat, ftInteger. We define the width and height in the case the content is a picture.

       SetExCellComm1 ( row, col, cell_comments, sheet )


This procedure sets the comments 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 the 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 in 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 relatively 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 the 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!