[VBA]
With ActiveWorkbook
With Worksheets("Sheet1")
.Copy after:=Wsm
ActiveSheet.Name = strfilename = mid$(wbkname, instrrev(wbkname, "\")+1 and _
Left(wbkName, Len(wbkName) - 4) & Chr(32) & Format(Now, "m-dd-yy")
End With
[/VBA]
is psuedo code
[VBA]
With ActiveWorkbook
With Worksheets("Sheet1")
.Copy after:=Wsm
ActiveSheet.Name = strfilename = mid$(wbkname, instrrev(wbkname, "\")+1 and _
Left(wbkName, Len(wbkName) - 4) & Chr(32) & Format(Now, "m-dd-yy")
End With
[/VBA]
is psuedo code
my site: www.ecboardco.com
was built w/ a majority of the assistance from the board members here... thanks VBAX.
Just because I see something, doesn't mean that what's actually happening is what I see.
You don't get from 0-90 by standing still!