请求帮助, 很简单VB问题: window.close cn过路人2004-03-05 20:13:55

My VB knowledge is almost 0, but I need to write some simple code for my excel project. How to use a variable fn2 to substitute the window name, "new_02_01_2004_3.XLS" for window.close? 谢谢您啦!

In VB:
Windows("new_02_01_2004_3.XLS").Activate
ActiveWindow.Close

fn2 = "H:\Administrative\SH\" & Sheet1.Cells(2, "Q") & "_" & Sheet1.Cells(23, "S") & ".XLS"

太简单了? 在线期盼等待高手. 提前谢谢了!