CCur Convert to currency (number) CDate Convert to Date. CDbl Convert to Double (number) CDec Convert to Decimal (number) Choose Return a value from a list based on position. CInt Convert to Integer (number) CLng Convert to Long (number) Command Return command line option string. In some examples we turn off Calculation and Screenupdating. The reason we turn off calculation is in case the range in which we are deleting rows contains lots of formulas, if it does Excel may need to recalculate each time a row is deleted, slowing down the macro. Copy Object (Do Cmd) Copy an Access database object. CSng Convert to Single (number.) CStr Convert to String. Current Db Return an object variable for the current database. Performance of custom scripts that automate large amounts of data entry or data collection will improve if you take the following two actions: The work Reflection performs to capture and save each screen can have an impact on scripts that send a lot of keystrokes to reach many host screens.
This is because they only delete one row at a time! However, the additional work performed by Reflection to make these features possible can have a negative impact on automated interactions with the terminal while a script, macro, or . Beginning in Reflection 2011 R3 SP1, while a Reflection VBA macro is running, the productivity features and Screen History are turned off automatically to improve performance.If you want to enable these features while automation is running insert the appropriate lines in the macro: (as described in the next section) to avoid possible performance costs introduced by these features.a Abs The absolute value of a number (ignore negative sign). Apply Filter Apply a filter clause to a table, form, or report. The screenupdating being set to false will also speed up our macro as Excel will not try to repaint the screen each time it changes.