I posted this in wrong forum initially:

-- I recall a command that would allow you to break off the filename from a
fullpath filename?
example= c:\cad\cadinput\41873100.DBF
How do I make iexample=41873100.DBF

I can create a function but doesn't VBA have a command to allow you to do
this?

Thanks
--
Ray