Issue Converting Sub to Function to End Main Sub after Called Sub Exits

Hello,

I have a main sub that is calling a sub to Import some Data and if it fails or returns a false, i want it to exit the Main Sub. I have read deep into forums and have found that the way to do this is by converting the called sub to a function then calling the value e.g.

Please Login or Register  to view this content.

. But I am having difficulties with my Function.

It is currently running the first part up to the 'else' or so where it opens the file but it will no longer copy the sheet to the workbook where the macro was called from it just leaves it open and will only copy the sheet if i leave the workbook open in the background and run it again. Please see the Function below and advise where this is wrong or if there is a way to achieve what I am trying to do with it as a sub.

Please Login or Register  to view this content.

Please let me know if i haven't included enough details.

Hi Mehmetcik,

Thank you for your help here. Your different approach has worked on the stopping the Sub if the Specific named sheet isn't found on the opened file (Which is great! one bug down). However i'm still having the issue where once it calls the Import_Data sub, if you select an excel file, it will open the file but wont copy the sheet over. Originally i got it to work all at the same time but now it just opens but doesn't copy unless i run it a second time.... am I missing a line of code?

Hi All,

Thanks for all of your updates. I have managed to replicate the circumstances when it works and when it doesn't. If I click 'Developer', 'Macros', Then select the macro and click 'Run' it will work and pull the data first time and close the book and continue the macro or end it if the sheet doesnt exist. However if I use the keyboard shortcut e.g. Ctrl + Shift + 'G' it wont run the full macro instead it will just open the workbook and leave it sitting there..... Thoughts?