Close workbook with use of filename?

[Kramxel]

Hi there,

I currently use the following VBA code to find the most recent file within a folder, open it and copy the data to another sheet. I'm looking for a way to close it again afterwards.

Please Login or Register  to view this content.

Currently I am relying on the user by presenting them with a prompt box, I would like to avoid this altogether. Does anyone have any suggesstions?

in addition I'm also wondering if it would be possible to enter the file name (actually part of the filename) returned with this code into a specific cell within the worksheet?

Many thanks in advance.

[Andy Pope]

Assign the workbook to an object when opening it. You can then use the object reference to close the workbook.

Please Login or Register  to view this content.

[Kramxel]

You Sir are nothing less than a legend!

Thank you very much for the help.... (learning as i go and know just enough to get myself INTO trouble, just not OUT of it)