Excel workbook won't close when using 'close' command

[Snoopy2003]

Hello,

I have an excel application (xlsm) and a database file (xlsx).
I open/close the xlsx file from the xlsm file - using open/close file and run queries using connection.
The xlsx file is located on a server and multiple users are connecting it.

In some computers the xlsx won't close.
I noticed it when I finished working with my xlsm file and intended to work with different excel file.

What can cause this ?
How can I insure the file is closed after close command ?

I am using the following code to open and close the workook:
Call OpenFileXLS(DBWorkbookName, DBWorkbookPath, "write")
Set TargetWorkbook = ActiveWorkbook
...
TargetWorkbook.Close saveChanges:=True


Thank you for your help

[Pichingualas]

Try with:

Please Login or Register  to view this content.

I hope that helps.

[Marcol]

There are two types of shared Excel files, those that are corrupted, and those that soon will be ... use Access, or similar, to avoid this problem.

[Snoopy2003]

Hello,

Pichingualas - Thank you. I will try it and tell you if it works.

Marcol -
Do You mean to use excel as front-end and access as back-end DB ?
Can the user use access run time if he does not have access software ?
Can you recommend on an example in order to learn how to do it ?

Thank you for your time and help

[Snoopy2003]

Hello,

Pichingualas - Thank you. You solved my problem.

Thank you for your support

[Pichingualas]

Glad to help

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.