[算表] vba規劃求解
軟體: excel
版本: 2016
各位版大好,今有一個檔案如下:
https://1drv.ms/x/s!AuJqZhIslJmbgels2xIuY5ArLsCUSexcelQ
裡面有一個巨集"solver",目的是要執行規劃求解。
這是我用錄製的,但是後來要再次執行的時候卻出現"沒有定義這個sub或function"訊息。
不知道有沒有解決方法? 謝謝!!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 114.40.10.252
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1473084998.A.712.html
→
09/05 22:23, , 1F
09/05 22:23, 1F
→
09/05 22:29, , 2F
09/05 22:29, 2F
→
09/05 22:31, , 3F
09/05 22:31, 3F
→
09/05 22:31, , 4F
09/05 22:31, 4F
→
09/05 22:42, , 5F
09/05 22:42, 5F

→
09/05 23:14, , 6F
09/05 23:14, 6F
→
09/05 23:14, , 7F
09/05 23:14, 7F
→
09/05 23:15, , 8F
09/05 23:15, 8F
→
09/05 23:15, , 9F
09/05 23:15, 9F
→
09/05 23:15, , 10F
09/05 23:15, 10F
→
09/05 23:29, , 11F
09/05 23:29, 11F
→
09/05 23:30, , 12F
09/05 23:30, 12F
→
09/06 07:17, , 13F
09/06 07:17, 13F
→
09/06 09:14, , 14F
09/06 09:14, 14F
→
09/06 09:14, , 15F
09/06 09:14, 15F
→
09/06 09:15, , 16F
09/06 09:15, 16F
→
09/06 09:17, , 17F
09/06 09:17, 17F
→
09/06 09:17, , 18F
09/06 09:17, 18F
→
09/06 09:17, , 19F
09/06 09:17, 19F
→
09/06 09:18, , 20F
09/06 09:18, 20F
→
09/06 09:18, , 21F
09/06 09:18, 21F
→
09/06 09:19, , 22F
09/06 09:19, 22F
→
09/06 09:26, , 23F
09/06 09:26, 23F
→
09/06 11:43, , 24F
09/06 11:43, 24F
Office 近期熱門文章
PTT數位生活區 即時熱門文章