help with macro that opens and close

[JasonLevan]

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

 

[the_net_2.0]

check out the :

application.workbooks.open("path")

method.

this is very easy. google it.

 

[JasonLevan]

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

 

[the_net_2.0]

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

 

[JasonLevan]

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.