close inactive file

**jseufert** · 09-21-2009, 01:02 PM

I'm using the

Please Login or Register  to view this content.

method to browse and open a file. i then copy some data to another file. My problem is that I can't seem to close that same file I opened with the get mthod. i know how to use the

Please Login or Register  to view this content.

proceedure to close the active window, but the file I want to close is not active at the time it needs to be closed, and I'll never know the name of the file since people name their files differently.

Heres my basic code:

Please Login or Register  to view this content.

JS

**Leith Ross** · 09-21-2009, 01:15 PM

Hello JS,

Since the file you opened is a workbook, you can close the file this way...

Please Login or Register  to view this content.

**jseufert** · 09-21-2009, 05:17 PM

That doesn't work either.

**Leith Ross** · 09-21-2009, 05:41 PM

Hello jseufert,

I must have not looked at your profile. It says you are using Excel 2007. The code I provided works in 2003. Which version is the workbook running?