Paul_Hossler
06-12-2011, 07:25 PM
I have a UserForm with an Image Control on it
I'd like to drag a CSV file and drop it on the image, and just be able to get the name of the CSV file so that I can read the lines with my module
What happens now is that Excel just opens the CSV file into a new WB
I was able to use the Animation control (which has an OLE Drag and Drop event) to return the name of the CSV file to my module, but it really looks ugly, just a gray box with a Control Tip that says 'Drop CSV here"
Is there any way to do it?
Paul
I'd like to drag a CSV file and drop it on the image, and just be able to get the name of the CSV file so that I can read the lines with my module
What happens now is that Excel just opens the CSV file into a new WB
I was able to use the Animation control (which has an OLE Drag and Drop event) to return the name of the CSV file to my module, but it really looks ugly, just a gray box with a Control Tip that says 'Drop CSV here"
Is there any way to do it?
Paul