Copy and paste filename

This is the first time I'm posting in this forum. I'm a creating a macro which does the following.
1)Compute average of a data set
2)Compute maximum
3)Compute minimum
4)Compute range (maximum-minimum)
5)Compute standard deviation
6)Automatic save file as <process name> <date> <running number>
For example: Length_07_02_07_1
_2
_3
_4
07_03_07_1

How do I perform step 6)? I want to maintain process name "Length" and change date according to the date on the computer. At the same time I want to increment the suffix "_1", "_2", "_3" ... each time the macro button is pressed. And I do not want to overwrite existing data/file.

Any help is appreciated.

Ed

Hi, Ed. Give this code a shot:

Please Login or Register  to view this content.

HTH

Jason