Close Excel File

[tnguyen]

Hi All,

I wrote this code to open an excel file when a button is pushed. I also have another piece of code to close the excel field when another button is pushed. The problem: the code to close the excel only works on my computer. There is no error message, but the file doesn't not close on others' computer. Can you please advise on a solution? thanks.

Here is my code to close the file:

Please Login or Register  to view this content.

Please help.

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.

[pr4t3ek]

Hi!

If you are purely after closing the workbook then I would probably just use

Please Login or Register  to view this content.

I think the reason why other people may not be able to close the workbook via your button is possibly because of Macro/Security Settings.
Tools > Macro > Security > Ensure checkbox is at "low" for all other user's.

Hope this helps...

[shg]

Ensure checkbox is at "low" for all other user's.

That is an invitation to disaster and an ocean of hearbreak. Never, EVER set macro security to Low.

[tnguyen]

I did give that a try and it didn't change anything. So i set it back to medium. Any other suggestions?

[pr4t3ek]

open attached workbook on other's pc and see if workbook closes when they click this button?

if it does then code behind method will work, there's something wrong with either your workbook or the code you are currently using..

let me know..

[shg]

I would say chances are you have Windows Explorer configured to hide extensions for known filetypes, and in so doing, you don't need to include the file extension in the workbook name. And the other computer isn't set up that way, and requires it.

So include the extension (xls, xlsx, xslm, ... as appropriate), which works on systems configured either way:

Please Login or Register  to view this content.

[tnguyen]

Thanks Shg. Your code works perfectly!