Application.GetOpenFilename, Attach files to Email, Move files, Delete Original.

Hello folks.

What im trying to do si use Application.GetOpenFilename--MultiSelect:=True to select some files and then i want to attach them to a email. move this original files to a new location, then delete original files.

Though i ran into a problem straight away.
when doing the getopefilename if i set the variable as a string i get error runtime error 13. so i set the variable as a Variant though when i put the variable value into a cell it only has one file name.

Please Login or Register  to view this content.

cheers

also got

Please Login or Register  to view this content.