workbooks.close method not working

[Sc0tt1e]

Hi all, this is most likely a very obvious thing I am missing but I am having trouble with the below piece of code and cannot work out why I cannot close the workbook I have opened and copied.

Please Login or Register  to view this content.

This is all the code I have so far so you can see the bigger picture (I can add workbook as well if it helps?)

Please Login or Register  to view this content.

[Bernie Deitrick]

Your FName includes the path. Use code like this, and create a workbook object to work on

Please Login or Register  to view this content.