I would like my database to open the open file dialog box which will displa only csv file upon selecting a csv file it will transfer the text into a temporary txt file for evaluation later. When the cancel button is clicked it will just return back to the database
I have managed to get an open file dialog, along with the only having csv file's and once selected it will copy the file into a txt file using the transfertext and file copy methods however whenever i click on the cancel button in the dialog box it tries to access the file copy method.
Is there a way of getting what I want without this actually happening. I tried if the file variable is null then exit sub but that doesn not seem to work.
It is probably something really simple and I am looking too deep and may just need a fresh eye on the issue