Close Workbook Based on Cell Value

[Trikageon]

Hi!

I am able to open the file I want using this:

Workbooks Range("bd1").Value & ".csv"

But how do I then close it later on?

If I understand how this works correctly, I need the full filepath to open a file (i.e. the value of cell BD1), but only the book name to close it, right?

In this particular instance, cell BD1 has the value "J:\DGR\DGR_Reports\DGRReportSupportFiles\dsr20140102", so I assume that, if I have a cell somewhere else with the value "dsr20140102" that I can write a code similar to the one above to close it...I just don't know what that would be.

Any ideas?

Thanks!

 

[Momentman]

Have you tried

Workbooks(Range("bd1").Value & ".csv").Close True

True- saves changes while false won't

 

[Trikageon]

Thanks, Momentman! I pasted that exact code, but I'm getting a debugging error. Any other ideas?

 

[Momentman]

Thanks, Momentman! I pasted that exact code, but I'm getting a debugging error. Any other ideas?

What's the exact error?