Hi,
Can anyone help with the following scenario:
I need to attach a file to the userform, or some spot on the excel sheet which communicates with the userform. I know that one can browse a file on userform using getopenfilename command and I can also set path onto a text box placed on userform. Now is there a way to load the selected file onto the form, with an icon ( as is done with Insert object function in Word and Excel). Is there a code for this.
If not , then can at least the data of the selected file(if selected file is excel) be copied in the current excel sheet( on which userform exists).
I am a novice when it comes to excel, hence any help is sincerely appreciated.