Excel精英培训网

 找回密码
 注册
数据透视表40+个常用小技巧,让你一次学会!
查看: 2714|回复: 0

能获取mp3播放时间长度,不能得到mid播放的时间长度,怎么回事?

[复制链接]
发表于 2012-3-29 21:47 | 显示全部楼层 |阅读模式
能获取mp3播放时间长度,不能得到mid播放的时间长度,怎么回事?
Option Explicit
Public Declare Function mciSendString Lib "winmm.dll" Alias "mciSendStringA" (ByVal lpstrCommand As String, ByVal lpstrReturnString As String, ByVal uReturnLength As Long, ByVal hwndCallback As Long) As Long
Public Declare Function GetShortPathName Lib "kernel32" Alias "GetShortPathNameA" (ByVal lpszLongPath As String, ByVal lpszShortPath As String, ByVal cchBuffer As Long) As Long
Sub getTest()
    Dim mPath As String, mTime As Long
    mPath = Space(16)
    Call mciSendString("status " & ActiveWorkbook.Path & "\mp3\" & Sheets("A").Cells(2, 5) & " length", mPath, 15, 0)
    mTime = Val(mPath)
    Sheets("A").Cells(2, 6) = Int(mTime / 1000)
    MsgBox (Sheets("A").Cells(2, 6))
End Sub


您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2024-5-17 18:49 , Processed in 0.197398 second(s), 8 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表