Where is CleanTrim actually located?
Is it in the workbook that might be renamed?
Do you actually need to specify the workbook here?
[vba]
Application.Run "'SalesTargets.xls'!Clean_Trim"[/vba]
Can't you just use this?
[vba]
CleanTrim[/vba]
Where is CleanTrim actually located?
Is it in the workbook that might be renamed?
Do you actually need to specify the workbook here?
[vba]
Application.Run "'SalesTargets.xls'!Clean_Trim"[/vba]
Can't you just use this?
[vba]
CleanTrim[/vba]