ä¸ãæå¼wordæ件代ç ï¼Set wo = CreateObject("Word.Application")
wo.Documents.Open ThisWorkbook.Path & "\æµç¨.doc"
wo.Visible = True
äºãæå¼pptæ件代ç ï¼æ¹æ³1ï¼
Set wo = CreateObject("Powerpoint.Application")
wo.Visible = True
wo.Presentations.Open ThisWorkbook.Path & filenameæ¹æ³2ï¼Sub dd()Dim filepath$, filename$
filepath = Chr(34) & ThisWorkbook.Path & filename & Chr(34)
Shell "POWERPNT.EXE " & filepathEnd Subéï¼åå»æå¼PPSæ件ï¼å¨æ¼ç¤ºå®åéåºPPSæ¶å¹¶æ²¡æPowerPoint主çªå£ä¿çï¼ä½å¨Excelä¸ä½¿ç¨VBAæå¼çPPSæ件ï¼å¨æ¼ç¤ºå®PPSéåºåï¼PowerPoint主çªå£ä»ç¶æå¼ã
è¿é使ç¨ä¸ä¸ªå¾ªç¯å¤ææ¼ç¤ºçªå£æ¯å¦åå¨ï¼å ä¸é误ææç¨åºæ¥å¤çä¸é¢è¿ä¸ªé®é¢ã
PrivateSub CommandButton1_Click()
Dim wo AsObject Dim app AsObject
' å建PowerPointåºç¨å®ä¾
Set app = CreateObject("Powerpoint.Application")
' 使PowerPointå¯è§
app.Visible = True ' æå¼PPSæ件Set wo = app.Presentations.Open(ThisWorkbook.Path & "\a.pps")
' å½PPSæ¼ç¤ºç»ææ¶ï¼wo对象çSlideShowWindowä¸åå¨ï¼ææå°é误
OnErrorGoTo errHandle
' PPSæ¼ç¤ºæ¶å
¨å±
追é®å¥ææ