stuartgb100
03-08-2016, 12:38 PM
Hi,
I have a VBA routine that allows a user to paste an email address into A1, and type the full path of a file to be attached into B1.
Is there any way (under Windows 7, not Excel VBA) whereby the user can navigate to their chosen attachment and (somehow) capture the full path & name, and copy it to B1 in the sheet ?
Thanks.
I have a VBA routine that allows a user to paste an email address into A1, and type the full path of a file to be attached into B1.
Is there any way (under Windows 7, not Excel VBA) whereby the user can navigate to their chosen attachment and (somehow) capture the full path & name, and copy it to B1 in the sheet ?
Thanks.