教師節的禮物
Dir() function not working in Mac Excel 2011 VBA - Stack Overflow教師節到了,布朗老師收到了好多孩子們送他的禮物。首先是一個開糖果店老板的兒子送他的禮物,只見他拿著禮物盒搖了搖。“我猜這一定是一盒糖果。”“噢,你怎麼知道的,老師?”“這是秘密!”老師笑著回答。接著送他禮物的是一個開花店老板的女Gianna, you cannot use DIR like that in VBA-EXCEL 2011. I mean the wildcards are not supported. You have to use MACID for this purpose. See this code sample (TRIED AND TESTED) Sub Sample() MyDir = ActiveWorkbook.Path strPath = MyDir ......
全文閱讀