Closing form doesn't stop program

[bvwalker1]

I have a form that opens a file and then makes some changes and saves it. The form has an exit button which unloads the form. However, this doesn't seem to release the newly saved file. When I exit the form via the upper right exit button X, it does. Is there another command I need to use in addition to unload form to get the program to completely release the file?

[Norie]

How are you opening the file?

[mehmetcik]

Please Login or Register  to view this content.

[Greg M]

Hi there,

I suspect that the problem lies in the method which you are using for closing the UserForm.

Insert the following code in a standard VBA CodeModule:

Please Login or Register  to view this content.

and use the following code in the CodeModule associated with the UserForm itself:

Please Login or Register  to view this content.

In general, UserForms should be instantiated, displayed (.Show) and unloaded from a calling routine located in a CodeModule which is separate from the CodeModule of the UserForm.

The UserForm should be hidden (not unloaded) by one or more routines located in the CodeModule associated with the UserForm.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[bvwalker1]

Hi there,

I suspect that the problem lies in the method which you are using for closing the UserForm.

Insert the following code in a standard VBA CodeModule:

Please Login or Register  to view this content.

and use the following code in the CodeModule associated with the UserForm itself:

Please Login or Register  to view this content.

In general, UserForms should be instantiated, displayed (.Show) and unloaded from a calling routine located in a CodeModule which is separate from the CodeModule of the UserForm.

The UserForm should be hidden (not unloaded) by one or more routines located in the CodeModule associated with the UserForm.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Thanks Greg. This was helpful. One follow up question if you don't mind. I open a .csv file initially using the first segment of code to see what it contains so I know its dimensions and fields and populate a combobox and then close it. I then open it for editing using the second method and after the changes are made the file is saved, but I intentionally haven't exited the form yet at this point. However, the file that I edited and saved cannot be closed at this point while the form is still running. Why is that? I have included my entire program below for reference.

Please Login or Register  to view this content.

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

Ah ok, if I had read your original post more closely I might have understood the problem better - sorry about that.

By default, a UserForm is Modal, which means that cells, worksheets, workbooks etc. are "untouchable" for as long as that UserForm is displayed. If you want to be able to access other items (e.g. to close the edited workbook) while a UserForm remains displayed, you must open it as a Modeless UserForm, i.e. instead of "TracFone.Show" you should use "TracFone.Show vbModeless".


Hope this helps - as before, please let me know how you get on.

Best regards,

Greg M

[Norie]

Where in the code are you trying to close the CSV file you've opened?

You should be able to do that whether the userform is modal or modeless.

[bvwalker1]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

Ah ok, if I had read your original post more closely I might have understood the problem better - sorry about that.

By default, a UserForm is Modal, which means that cells, worksheets, workbooks etc. are "untouchable" for as long as that UserForm is displayed. If you want to be able to access other items (e.g. to close the edited workbook) while a UserForm remains displayed, you must open it as a Modeless UserForm, i.e. instead of "TracFone.Show" you should use "TracFone.Show vbModeless".


Hope this helps - as before, please let me know how you get on.

Best regards,

Greg M

Thanks Greg! Both of your posts were very informative and useful to me. I tried to give you more credit for the additional response, but the system wouldn't let me.

[bvwalker1]

Thanks Greg! Both of your posts were very informative and useful to me. I tried to give you more credit for the additional response, but the system wouldn't let me.

Where is TracFone.Show located? I do not call this explicitly anywhere so is it being called behind the scenes somewhere? It's my main form.
Thanks, Greg!

[Greg M]

Hi Brian,

Many thanks for your PM - I hope my reply helps to keep you moving in the right direction.


Hi Norie,

The edited workbook is NOT being closed from the UserForm - my understanding is that the OP wants to keep the workbook open (and "accessible") while the UserForm remains displayed.


Regards to you both,

Greg M