I am having a problem with Application.GetOpenFilename.
I am opening up a dialog box that allows a user to choose one or more files.
Briefly, the problem is this. Everything works well in the code below unless the user clicks cancel on the dialog box. Then I get a run time error '13': Type mismatch. On the line with Application.GetOpenFilename. My code is below.
Any thoughts would be appreciated, this is driving me crazy!!
Please Login or Register to view this content.
Last edited by brl8; 01-03-2011 at 04:57 PM. Reason: Mark solved
Consider getting in the habit of passing arguments be name rather than position.Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Thank you for your response shg,
That was actually what my code looked like initially. I changed it back per your suggestion and I'm still getting the type mismatch error. I've even updated the Application.GetOpenFilename command in case I had something slightly wrong there. I've attached the updated code.
Any thoughts will be appreciated as I can't figure out what is going on.
Please Login or Register to view this content.
You've still got FileName declared as a dynamic Variant array. It should be declared as a simple Variant as in my example.
Oops I missed that! That did it, thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks