[VB6 ] 請問一下用filelistbox開啟excel問題
不好意思...
原本用EXCEL開啟檔案的語法是:
Set oBook = oExcel.Workbooks.Open(App.Path & "\" & "test.xls")
或
Set oBook = oExcel.Workbooks.Open("c:\test.xls")
但是今天小弟想
用filelistbox裡的Excel開..
Set oBook = oExcel.Workbooks.Open(" ????? ")
這裡的語法要打什麼呢?
感謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 123.195.0.26
推
08/18 14:02, , 1F
08/18 14:02, 1F
→
08/18 14:03, , 2F
08/18 14:03, 2F
自問自答
找到答案了XD
Set oBook = oExcel.Workbooks.Open(File1.FileName)
※ 編輯: chrishappy11 來自: 123.195.0.26 (08/18 19:10)
→
08/20 20:07, , 3F
08/20 20:07, 3F
→
08/20 20:08, , 4F
08/20 20:08, 4F
→
08/20 20:08, , 5F
08/20 20:08, 5F