2009-10-19 10:02
cdd
[問題]Excel Call 其他Sheet的問題?
首先, 我有兩個檔案放在c:\documents and settings\benheung\desktop\temp\test\several,
screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor='hand'; this.alt='click here to open new window\nctrl+mouse wheel to zoom in/out';}" onmousewheel="return imgzoom(this);" onclick="if(!this.resized) {return true;} else {window.open(this.src);}" border=0 alt="" src="http://hk.geocities.com/hskgod/dir.jpg" onload="if(this.width>screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.alt='click here to open new window\nctrl+mouse wheel to zoom in/out';}">
其中, docn001.xls中sheet1 名為「source」, 在cell-a1中有[hellow!]一字。
screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor='hand'; this.alt='click here to open new window\nctrl+mouse wheel to zoom in/out';}" onmousewheel="return imgzoom(this);" onclick="if(!this.resized) {return true;} else {window.open(this.src);}" border=0 alt="" src="http://hk.geocities.com/hskgod/docn001.jpg" onload="if(this.width>screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.alt='click here to open new window\nctrl+mouse wheel to zoom in/out';}">
在docn002.xls中有兩張sheet, 分別為「par」, 及「output」, 其中「par」有path, 及docn001.xls, 的file name。
screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor='hand'; this.alt='click here to open new window\nctrl+mouse wheel to zoom in/out';}" onmousewheel="return imgzoom(this);" onclick="if(!this.resized) {return true;} else {window.open(this.src);}" border=0 alt="" src="http://hk.geocities.com/hskgod/docn002.jpg" onload="if(this.width>screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.alt='click here to open new window\nctrl+mouse wheel to zoom in/out';}">
請問在output的a1要怎樣輸入才能利用「par」內的參數,顯示 docn001.xls中的「hello!」?
screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor='hand'; this.alt='click here to open new window\nctrl+mouse wheel to zoom in/out';}" onmousewheel="return imgzoom(this);" onclick="if(!this.resized) {return true;} else {window.open(this.src);}" border=0 alt="" src="http://hk.geocities.com/hskgod/out.jpg" onload="if(this.width>screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.alt='click here to open new window\nctrl+mouse wheel to zoom in/out';}">
即怎樣做到做到
='c:\documents and settings\benheung\desktop\temp\test\several\[docn001.xls]source'!$a$1
的效果, 而「'c:\documents and settings\benheung\desktop\temp\test\several\[」及「docn001.xls」在par裏拿, 即是如果轉變par內的值會在output中call 不同的數據。
?