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

来源: cn过路人 于 2004-03-05 12:13:55 [] [旧帖] [给我悄悄话] 阅读数 : (405 bytes)

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"

所有跟帖： 

• 太简单了? 在线期盼等待高手. 提前谢谢了! -cn过路人- ♀ 给 cn过路人 发送悄悄话 (0 bytes) () 03/05/2004 postreply 12:43:26

请您先登陆，再发跟帖！