I need a macro that will open one workbook and go to it, but close the one it just came from so i dont have it open anymore. It does not need to save changes when it close.


Thanks

check out the :application.workbooks.open("path")method.

this is very easy. google it.

check out the :application.workbooks.open("path")method.

this is very easy. google it.

but how do i get it to close the other one

http://www.exceltip.com/st/Close_a_workbook_using_VBA_in_Microsoft_Excel/469.html

I saw this but my problem is that once I switch over to a new workbook the one I want to close is not the "Active.Workbook" so how do i get it.