Excel精英培训网

 找回密码
 注册
数据透视表40+个常用小技巧,让你一次学会!
查看: 2723|回复: 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


excel精英培训的微信平台,每天都会发送excel学习教程和资料。扫一扫明天就可以收到新教程
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2024-6-15 14:38 , Processed in 0.165793 second(s), 7 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

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