请求帮助, 很简单VB问题: window.close

来源: 于 2004-03-05 12: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"