Dim app As Object, wb As Object
Dim xlsht As Object, xlrng As Object
Dim i, j, f As Integer
Set app = CreateObject("Excel.Application")
app.Visible = True
Set wb = app.Workbooks.Open("E:\" & "\生日提醒1.xls")
Set xlsht = wb.worksheets(1)
With wb
With xlsht
wb.worksheets("生日提醒").Activate
Shapes("TextBox 1").TextFrame.TextRange = Sheets.Application.ActiveSheet.Cells(1, 8).Value
End With
End With
我想实现PPT中的TextBox1可以从一个表格cells(1,8)取值,我做完后运行为什么报错啊,高手帮指点一下
Shapes("TextBox 1").TextFrame.TextRange = Sheets.Application.ActiveSheet.Cells(1, 8).Value
è¿è¡æ¶ï¼åªæè¿æ®µæ¥éï¼ä¸ç¥æä¹åäº
ä»ç»çä½ è¿å¥ï¼ä½ çSheetsæ¯ä»ä¹ä¸è¥¿ï¼æºå¨æä¹ç¥éï¼
åæ¶ä½ çwithåend withï¼ä½ è¿å¥åºè¯¥ä½¿ç¨å
¨ç§°ï¼å¤§æ¦æ¯è¿æ ·å§ï¼
Shapes("TextBox 1").TextFrame.TextRange = wb.ActiveSheet.Cells(1, 8).Value
æè
ï¼
Shapes("TextBox 1").TextFrame.TextRange = xlsht.Cells(1, 8).Value
æç½äºæ²¡æï¼wbãxlshtææ¯ææçåéï¼å¨PPTéé¢æ æ³è¯å«Sheetsè¿æ ·çä¸è¥¿ã
è¿è¡åï¼è¿æ¯æé®é¢ï¼ä¸ç¥éåªéæé®é¢
以ä¸ä»£ç è°è¯éè¿ï¼ä¿è¯æ£ç¡®è¿è¡ï¼å¸æå¯¹ä½ ææ帮å©ï¼
Option Explicitä½ å®ç¾ç解å³äºæçé®é¢ï¼ï¼è°¢è°¢
ä½æ¯ä½ ç¥éæçé£æ¡æ¥éæ¯æä¹åäºåï¼
ä½ å¯¹æ¯è¯å¥å·®å¼å°±æç½äº