Error message with application get open filename

Hi Arlu

I tried that - but a message comes back to say I selected false - it works fine if the user selects a file but if they press cancel - then this is where my troubles begin

thanks a lot
Leanne

Thanks Arlette - I will give that a go and ta for explaining the code.

One more thing if you could help me with I would be very appreciative - you helped me before with the code to open the filename, when I select the file, even when I am finished the whole macro the file selected at the start remains open.

What code would I use to close that particular workbook. I tried activeworkbook.close, weeklyfn.close etc but no matter what I try it remains open.

Please Login or Register  to view this content.

Originally Posted by leanne2011

Thanks Arlette - I will give that a go and ta for explaining the code.

One more thing if you could help me with I would be very appreciative - you helped me before with the code to open the filename, when I select the file, even when I am finished the whole macro the file selected at the start remains open.

What code would I use to close that particular workbook. I tried activeworkbook.close, weeklyfn.close etc but no matter what I try it remains open.

Please Login or Register  to view this content.

hi Arlette- this still does not work for me. It works if the user presses cancel, the user is forced to exit out of the macro. But when the user selects the file they are presented with a run time error 13 - Type Mismatch ? Any ideas

And the Workbooks(WeekFN).close worked perfectly - thanks for that
Kind regards
Leanne

Hi Arlette

I saw post 4 and your most recent - they both give an error message 13 - type mismatch. As I said - works fine if the user presses cancel - but when the user trys to select the file they are presented with the error message

thanks
leanne